Fancy brand new equipment sure was a nice change while I was in that class
It's more "clean" rather than fancy that gets the job done right.
A decent temperature controlled soldering iron, with good heat capacity, using the right tip for the job, clean solder on clean parts. Those are the main tickets to good soldering.
Even if you've got shaky hands, if you've got good heat with clean parts and materials, the solder will only flow where it can flow and needs to flow, and if you feed in the right amount of solder, you'll get a good joint. Period.
At this school (and in the shop I used to run), we had PACE PRC-2000 stations with practically every tip imaginable...and I can imagine quite a few tips. Along with that, an almost unlimited supply of "Kim-Wipes", fresh lab quality iso-alcohol, fresh RMA flux, q-tips, a decent set of various dental tools, Meiji microscopes, and the list goes on.
None of that stuff matters without clean equipment and parts.
Even now, some 3+ years after I've retired from the USAF, I still try to hold myself to those standards in my own work.
As for my soldering type equipment...
Weller WESD51 soldering iron station with a handful of various tips
"insert brand name here" 858D hot air gun
ZD-985 de-soldering tool
A bin full of various dental tools. Brand new, they're all expensive. I go to a couple of local dentists once in awhile and ask them if I can look through (and take some of) their 'broken' dental tools. One time I paid the guy $20 for a handful of broken stuff. Most of those tools are have tips on both ends. One tip breaks, the whole tool is broke for them...not for me.
A few quarts of fresh lab quality iso-alcohol along with a bunch of lint-free wipes and q-tips (cotton swabs) for cleaning.
Fresh flux. I only keep a pint or so on hand. That way I have to order new stuff once in awhile...keep it fresh.
Cheap $30 USB 'microscope' for inspection. Gonna upgrade that sooner or later with something like Dave's MANTIS scope.
Good light source. I prefer a bunch of incandescent lights with reflectors. LEDs and Fluorescent lights aren't the right 'color' for my tastes.
All in all, maybe $300 of equipment/material for a decent hobbyist bench.
Can you get away with less? Sure. Just keep it clean.
Want to spend more? Sure. Spent $100K on equipment. But if it isn't clean, a $50K soldering station won't make up the difference.