Look into a Subaru Forester? That'd be my guess.
I just bought a small SUV a couple months ago and did a bunch of research. Agreed with ShawnD1 on the CR-V... it's gotten great reviews but it was an automatic no-go for me with the weak 4 cylinder. No other engine options. They might not mind that though.
I wound up getting a RAV4. It's got one of largest cargo capacities of the small SUVs, drives relatively well, and the V6 has plenty of power.
If they're worried about snow, AWD, and whatnot the Subaru Forester might be the best option if they want something else to look at. There's a turbo option that makes it pretty peppy but that might be over what they want to spend. Even if they don't care about having a more power, the Forester might handle winter conditions better. I passed on it because it was a little smaller, only has a four-speed auto, and preferred a bigger V6 to a small turbo-ed four cylinder. Overall it seems like a another great vehicle though.
Thankfully, the small SUV market is highly competitive so there's plenty of good options depending on what they want.