From the little I've seen so far, I completely agree. And I'm not too interested in astrophotography, so that does not apply to me at the moment.
I think I start with low expectations: I never looked through a telescope - hence basically anything will be amazing for me. For many beginners like me, there is a lot of FOMO involved, as in: "sure, an 8" dobs is not very usable where I am, but WHAT IF I get to go to a dark sky?". But I realize that it's mostly due to not knowing much. Eventually, like you say, I will probably settle for a telescope that is portable and as cheap as possible, and invest e.g. in better eyepieces that will always get used 🤣
I figured that bortle 7 (same situation for me soon) would make any search difficult. I also feel that online one finds too much content for beginners dedicated to how to see DSOs, which pushes many to think that you need aperture to enjoy astronomy. I bought 10x50, instead of 8x42, for that exact reason, and then realized that it wouldn't really matter in polluted skies. On the other hand, I'm discovering so many other things like double stars (I split something easy like Nu Draconis last week, and it was SO exciting) but one has to search for that kind of content, and it's a shame.