I've always used regular plug-in irons, and found that Wellers had the best tips of those sorts. 40-60 watts.
Then, at a hamfest, I bought a no-name soldering station that I used for a while, and really it was no better than the individual pens.
Recently, I gifted myself a Weller WE1010NA from Amazon. It was cheaper than the Hakko, but it is not an active tip. No problem--it is temperature-controlled and heats up in ten seconds. I'm sure there are better irons out there, but this one has been fine for me.
But we have to realize that a soldering iron has about four major application contexts that will affect the choice. First is an solder station for SMD work. Others will have to comment on that--I can't hold my hand steady enough to solder SMD boards.
The main one for the Weller station I bought is for PCB's that have discrete components and inline-pin chips. It works great for that.
The third use case is for heavy wire connections, like power connections that have to carry more than an amp or two. These takes some serious heat (not merely high temperature, but total head) to get the big wire hot enough to make the solder flow. My last experience with that was trying to solder the power connections for a 600-watt radio transmitter amplifier. I needed to borrow my wife's fat-tip 100-watt stained glass iron to get enough heat into that heavy wire and those big terminals to make the solder flow.
Finally, there is soldering of heavy wires to other heavy wires, and for that I prefer a 150-watt soldering gun. The big 100-watt iron would do that, too, of course. I use either for soldering radio antenna terminals, where soldering the shield of, say, RG-213 to the shell of, say, a UHF plug takes some serious heat.
I once soldered welding cable to a copper terminal for a battery connection, because I lacked the appropriate crimper and time was of the essence. I had to use a propane torch for that one. Bigger stuff than that (plumbing, brass musical instrument repair) requires a torch.
Rick "recognizing that the Weller station is old school, but think a hell of a lot of very nice stuff was made when that stuff was the SOTA" Denney