I'd love a TW, they look like a lot of fun to rip from camp to the store, gravel roads, mild offroad, turn off brain and twist throttle, nothing but good things come of that. I actually got my motorcycle endorsement riding one years ago. If had the room I'd 100% have one with rear rack and some nice panniers.
Not to disparage anybody, but no, they can't go places a proper dirt bike can in the hands of a competent rider. The fat tires limit their use on trails with ruts and lack of suspension limits their use on rough terrain / woops, say down in Baja. While they may be ok for loose sand at slow speeds any proper offroad DS bike with good tires ridden by a solid rider is going to go further, faster with more comfort in 95% of terrain. Not saying that to be ornery but setting expectation, if you want to take the time to learn to ride a full size DS bike, a full size DS is likely a better option. If you want to dabble in motorcycles and don't want the option of harder single track, TW200 may slot in nicely.
I think as some others have said, a TTR230 or CRF250F would be my overall choice and a platform that is a bit more flexible.