A big part of the problem is that these movies were written, basically, for 12-year old boys. You're not going to be able to get that spark back as an adult, and it's not easy to make a movie that appeals so strongly to both demographics. And much like wu-tang, star wars (and other fun stories) is for the children. Andor is at least more adult-oriented, I think.
So, do I like the new movies? No, I literally slept through the last two they were so boring, and I found the lack of coherent plot baffling. And yes, it does make me a little sad. But seeing little girls dressed up like Rey, I'm reminded that there are better things for me to care about.
But there's a reason why the star wars fandom has such a stank reputation, and it's 100% because adult men care way too much about something meant for children to a quite creepy extent. Two things immediately come to mind: 1) the explicit and physical sexualization of Leia, which I understand but definitely don't think was necessary in retrospect (at least not so ham-handedly), and 2) the abuse of the guy who did the Jar Jar Binks voice acting. It's not his fault Lucas wrote the character as a moronic alien speaking patois. I wasn't aware of the abuse until long after it was over, but I adored jar jar binks as an eight year old boy and didn't understand why he was thereafter sidelined. This makes me also question whether criticisms by adults of the new content is a reflection of what we actually loved growing up. Could a character as weird as Yoda make it into a film now without catering much stronger to people eager to deconstruct him into eg orientalist stereotypes? Would Luke really be allowed to kiss his sister? Would Han Solo be allowed to shoot first, really?
Even the sexualization of Leia—look I'm into pulp fiction, I understand what shallow sexual stereotypes can deliver in terms of entertainment, it wasn't and still isn't crazy. You can see the same phenomenon in the current explosion of mass-published erotica ("romance"). But the stories I've heard about what Fisher was subjected to make me look at the fandom with pretty severe prejudice. It makes nerds look bad, and I also think the success of Indiana Jones shows that this wasn't necessary. It's also not the easiest thing to explain to a child or teenager who grasps something of the power dynamic between Jabba the Hutt and Leia but doesn't have the social knowledge or, frankly, cynicism to make the sense of it we do as adults.
Season 2 of the ILM documentary on D+ goes into this, it’s a really fascinating documentary for folks into special effects and/or star wars.
I've never given up on Star Wars, though obviously there's little good to be said about the sequel trilogy and much of the Disney output. It took me a long time to even see Rogue 1, but I recognized it was something special, and Andor even moreso. (Though I will admit I like eps. 2 and 3 of the prequel trilogy more than I did at first.)
Star Wars after Jedi is garbage. Lucas got me with those awful prequels and Disney got me with the first 2 new movies. I will never watch another Star Wars anything outside of the original 3 movies.
Either you never really abandon your Star Wars fandom or you're lying. There can be no other choice.
One cannot be shat upon by corporate hucksters that much and still think, "okay. I'll give 'em one more chance to shit in my eyes and ears"
Is just not possible.
Update: Clone Wars especially benefits from finding a good best-of episode guide to help move the story along.
And from there it was pretty much further and further downhill, with occasional glimpses of hope that were quickly dashed. I tried to watch a couple more entries after the prequels, but I finally gave up and wrote it off. I've missed almost the entire last 10 years of content.
A buddy at work finally convinced me to watch Andor, and I'm so grateful he did. It is superb. I read a reddit comment that said, "This is the show that made me feel ok to be a Star Wars fan again," and I can't agree more. In a lot of ways it still feels different from Star Wars. It's hard to explain because it's in the same universe, and has similar themes (which is why it doesn't feel totally out of place), but the tone is different. It's not about Jedi knights on a mission from destiny. It's about ordinary people making decisions, and choosing hope, in the face of the oppressive might of the Empire. But god is it good. Excellent writing, great acting, suspense, intrigue, nuance, and powerful emotional scenes (that are earned by proper story buildup).
So all of that is to say, it might not be exactly what you expect, and it won't simply be "Star Wars, again," but yes you should absolutely watch it. It's a fine work of art.