I'm probably older than most of your parents, my take on Kyle's introduction.
I was never a Hal fan, there weren't that many such creatures as the GL book was consistently mediocre through most of the 80s and into the early 90s. There was an editorial decision to replace the character which would've probably been fine or at least acceptable to most GL fans if it'd been handled well, instead they took one of the JLA founding members and turned him into a homicidal maniac all within a single issue.
Did Guy or Jon step up to become the new GL, any other long-established character in the GL mythos? No, they gave the ring to to kid they'd introduced the month before since they deliberately wanted a clean break. Wanting more of an everyman take instead of the GLs being the best a world can offer when it comes to willpower, we even get a "you shall have to do" from the last Guardian.
Then we had editorial mandate that Kyle hadda be pushed hard by all other books not just his own. Kyle polluted Morrison's excellent JLA run when he was forced to continually promote Kyle as the best GL evar while clearly showing him as a bumbling idiot.
DC editorial set up the character to be as unlikable as possible to not just Hal fans but fans of the GFL mythos. Not just kill Hal off but ruin his legacy. Kill off the Corps. Give the ring to a literal nobody.
The thing is, I was a Barry fan but had no problem with Wally stepping into the role, it was organic, it just felt right. But Kyle represents every wrong with the 90s revamp mentality. Kyle himself isn't the problem, if he were introduced as a new/additional GL today he'd receive a warmer welcome, but in 1994 he walked into your house and took a steaming dump on your living room floor, there wasn't much to salvage that first impression.