Nah, he's not the best character but he is in the top three with Kyle Rayner and Guy Gardner imo. Hal is generic and was only good when he became Paralax.
Theres alot of reasons. The entire Green Lantern mythos has changed since both of those stories. Hal resurrecting Coast City happened in the 90's. Batman being rejected by the ring happened in the mid 2000's.The Guardians arent even in charge of the corps anymore, so they dont sanction what the lanterns can or cant do unlike the Coast City situation with Hal. Also John Stewart has ascended into something greater than a Green Lantern. He's technically a Guardian now. So I think that's why he's able to use the ring for his own personal gain.
He wasn't an "anti hero" tho?!? You think leading/manipulating a bunch of emotionally vulnerable incels (cult style) into planting bombs and shooting people is anti hero behavior?
This also sort of happens in the manga industry because there are artists and creators who get fewer breaks and have a lot of health problems on their favorite jobs. I’m just sad that the anime industry has a lot of toxic work culture of forcing animators to make a lot of anime series.