You need a microscope for fine-pitch SMD. Otherwise it's like shooting in the dark, even if you have excellent eyesight.
BGAs are an exception though, since even with a microscope, you wouldn't be able to see anything much. So what you need is some good flux, some technique and a hot air gun, or a hot plate, or a mix of both, or a reflow oven if you can afford that (you can find small affordable ones these days...)
I personally do not like QFNs. They are the most annoying to hand solder reliably, unless you can use a stencil. Just my opinion though, as apparently some people can handle them with one hand and eyes shut.
But for hobby stuff, as Someone said, you can go the dev board/breakout board/SoM/... route. Sure not every component will be available in this form, but still a lot can be done.
As to the future of all this, having no crystal ball, I don't know. Is the hobbyist market going to disappear altogether one day? Are conventional PCBs going to themselves be obsolete (and replacement tech going to be completely out of reach for hobbyists)? Who can tell.