Even with Technician you may be able to do POTA or SOTA successfully on VHF.
But I do agree, the real meat of ham radio is when you get your General and get on HF. It opens up the door to the rest of the world, not just your local city.
DMR has a lot of traffic and you can get a decent DMR handy-talky for about $150 so it's worthwhile.
But the heydays are over. During the 80s/early 90s it was really hard to break into the chat when I was driving to work. So busy. Back then there were no legal issues with speaking into a microphone while driving either. So it made the morning traffic much more fun.
But then the internet came and the whole "speak to people all over the world for free!" thing really lost its shine. The home computer before that did a lot already too (until they came on the scene pretty much all geeks were hams)