What about a MINI Countryman? I have had a Cooper S All4 for several years and it’s been a great car - not too big, plenty of room inside. Quite nippy.
Might be at the top of budget and not sure about actual off-roading but mine has been perfectly fine on the occasional field/muddy car park.