Does the OP want a 4×4, or a vehicle with 4wd ability for the winters like we’ve endured for the last couple of years?
A proper 4×4 is about ground clearance, axle articulation, gearing, & tyres. Nissan Terrano IMHO.
A 4wd car is about comfort & economy, and some sort of intelligent 4wd system that prevents a numpty doing the transmission damage. X-trail, Hyundai/Kia efforts, BMW, even Audi I suppose.