Less mass is more fun off road
Heavy bikes are neither much fun, nor particularly practical when it comes to riding off road. I'd suggest go for a quarter litre dual sport if you want to ride to where you want to leave the road. Get a dedicated off roader if you can haul it to where you want to go, on a pick-up or trailer.
I don't really go the term "dual-sport", probably coined by marketers. The bikes are seldom very sporty in use, and / or somewhat compromised on the road. "Trail bike" was the term used years ago to describe a bike that could be registered for the road, and take on the rough where the road ends.
there are old motorcyclists and bold motorcyclists
but you seldom meet an old, bold motorcyclist