you will be bored
with anything less than a 650 dual sport within 1-2 years.
How do i know? You initial post reminds me of someone I know-Myself!
Fortunately, most 'failed experiments' can be resold with minimum financial penalty.
Get the bike you want and don't worry about the weight of a 650--practice makes good. NEVER PERFECT.