I agree on the mid- to late-'90s golden age. Especially with Star Wars, it was a fun time with all the non-movie stuff going on.
Part of when things took a turn for the worse with Star Wars was the release of Phantom Menace. Surprisingly, it was very divisive in those days and quickly turned into OG fan versus Prequel fan.
The prequels were kind of a perfect storm to mess up the fandom.
First, the franchise caesura between the mid-‘80s and 1999 ensured an entire generation of fans (who had grown up making their own stories with their action figures) had their own ideas of the prequel story (I know I did). The films could almost certainly never live up to the movies in our minds. (To me, for example, Yoda should always have been the old wise hermit you go to see to get trained - not Principal Weatherbee a mere 20 years before ESB.)
Second, the films themselves were not great, to put it mildly. There were some good ideas and some great designs, but the dialogue and acting were all bad, and I put that primarily on Lucas’s shoulders and not the actors’. Lucas shouldn’t have directed the movies himself, and he really needed some people around him who could say “that’s a bad idea, George” (whom he’d listen to).
Finally, the prequels were aimed at kids in a way that - no matter what George says - the original films just weren’t (ESB is not a film *just* for children). It’s very clear now that an entire generation of young kids grew up on the prequels and love them now, but us old farts who lived through that long drought just couldn’t view the prequels outside the context of the original films. The original films circumscribed our experience of the prequels in a way they just didn’t for the children who saw them.
What’s interesting is in a couple of decades, I strongly suspect the sequels will get rehabbed by creatives who were kids in 2015-2019 (especially female fans). (That said, as an OT fan I don’t know I can ever come around on the sequels, given the depressing fates my heroes came to and the fact they couldn’t get Luke, Leia and Han in the same room over three films. Inexcusable.)