I don't think there will ever be a stock bike like the one you want, sorry. There is simply too much variables, and it is impossible to cater to everyone's whim. I wholeheartedly agree that there is a certain set of common basic things that everyone seems to want, but the moment you remember that people differ too, the commonality dilutes. Where you ride, how you ride, it all matters very much.
I know people who can ride the big GSA anywhere in a way that I wouldn't be able to match on a two-stroke. People like Lyndon Poskitt effectively rebuild stock KTM rally bikes into a fully personalized and customized machines and whip those around the world, including Dakar - but then Lyndon can probably strip the bike down to fittings and back with his eyes closed after being woken up in the wee hours of the night.
My "adventure" (I'm not a very aggressive rider, but I enjoy and cherish the ability to go down a forest trail if I feel like it) bike of choice was the Husqvarna Terra TR-650, which is really a G65GS Sertao but with a better engine. I still have it as my European fly-n-ride bike, and like it very much, but it was also not perfect stock. Suspension is just okay stock (definitely not okay for more aggressive terrain long term), no windscreen to speak of, not as heavy as BMWs but definitely not as light as it could have been, etc and so on. I spent a year farkling it out the way I wanted.
After moving to Israel I decided against importing the Husky (too expensive, both import and ownership - moto insurance here is insane), and after a couple years sprung for CRF250L Rally. It's not that there is nowhere to ride here, far from it! But there is nowhere to ride far. Everything is within a day's ride. The little Honda is definitely underpowered - it rolls okay at 75mph on highway to get somewhere, but if there's crosswinds or hills, it's more or less dead in the water at those speeds. But as a combined daily nimble commuter and something to take on some forest trails or desert rides with not too much whooping, it's pretty fine. Some farkles incoming, of course, it's inevitable :)
I agree that it's larger cousin, CRF450L, sounds intriguing, but we'll have to see and even then, you will want better hand protection, electric stuff for your GPS (and heated clothing if up north), your favourite wider pegs, wind deflectors on the stock windshield, maybe protection bars, maybe something for luggage - the list is endless. Test rode CCM at the Overland Event in UK couple years back - it's a very interesting bike, but even if you could get it, it wouldn't be ready for you stock anyway, too (starting from windscreen and tank).