A bit late to this thread, but some thoughts:
A view held by some is that a good set of really gnarly tyres on a 2-wheel drive will get one to most places over pretty much anything. Not tested by me, so I will not comment other than to say that I can't believe it would cope particularly well with gloopy mud no matter how gnarly the drive tyres might be.
Mention has been made of the Dacia Duster 4WD: I have a diesel Duster of 2013 vintage (made in India). Do not buy a "made in India" version would be my recommend - early rust issues. I've lost count, but I think I'm in for my 5th warranty rustiness-repair this July. Dacia moved Duster production to Europe not long after (can't remember when exactly) so check, if 2nd-hand, where it was built as I seem to think Euro' build versions much better (and they will likely have a newer generation turbo diesel 1.5 engine which, I can say, will be noticeably perkier).
That said, I really do like my early Duster and, @ 55k miles, can't see myself exchanging it any time soon. It has v good ground clearance/angles for an "SUV"; the 4WD version's 1st gear is real "bottom gear" stuff (no good for launching oneself cleanly into traffic - have to pull-out in 2nd for that). Boot is spacious, but I have still envied a friend's 2WD Saab and now Ford estate's seat-down boot length. Electronic 4WD control is off/auto/full-time + I went for traction control option (which can also be turned on/off): all Nissan based.
I'm almost always fully loaded with gardening gear and frequently with roof-bar load as well: presently I get just over 37 mpg, but I have managed some 43 mpg over extended periods with more normal use - still no where near "official" mpg figure, but still decent enough.
As much as I really like my Duster (bought new, because they were very new to the market), I do wonder sometimes whether a used Nissan X-Trail 4WD with 2Tonne towing capacity might have been the way I should have gone. (The X-Trail had it's own problems - according to web searches - but, then, we all know about Land Rovers too !! )