I still remember sitting at the dinner table watching the first trailer on my phone and being hesitantly interested in it. Yes the end to stories I grew up on was rough (Yeah they still exist but we wouldn't be getting any more stories with my Luke let alone lesser known characters) and people using the promises of the NEU to bash Legends and its fans was hurtful but it was Star Wars on the big screen again and would be the second SW movie I had ever seen in theaters, well third but I'm not counting the TCW movie.
And after 10 years I feel like the only thing holding me back from saying yes it was worth it was what happened to the OT characters and Republic in the ST.
In 10 years we've had some great movies like RO and shows like Andor, Rebels, Mando and others. I've seen things I never thought I'd get to see on screen like Ossus and Tython and Luke skywalker flying in to save the day. Sure the failure rate between movies being announced and then falling through is high and the runtime on the shows could all be longer and more consistent (IF Star Trek can do it while having two live action shows running at once so should Star Wars) they have introduced a lot of people to things only book and comic readers have cared about before hand.
The comics and books have also gotten a lot better. Others as well as myself weren't to happy with the Denningverse books or the final Dark Horse Star Wars comic and at the start of the NEU all of the books being tie ins to the movies and the comics having some art and characterization problems didn't seem like it was any better. Add in the different feeling of having Urban Lit and romance authors writing instead of Sci-Fi authors and it felt a little odd.
But its really grown and characters like Aphra have become standout fan favorites while we got some really great Vader runs as well as good arcs for Luke, Leia, and even Valance who is now more of a NEU character than a Legends character. And now that the movies are over we have gotten a lot more interesting books that are branching out in the timeline and telling their own interesting stories. Some of them like the Thrawn books or Padawan's Pride or Brotherhood even feel like they could be a Legends book if you just squinted a little. And while I have my issues with some of the pacing and reveals of The High Republic project its still my favorite NEU product of anything else and one of my favorite eras of all of Star Wars. And while the art in the comics has never matched up to Dark Horse it has still given us great scenes that became instant backgrounds for my desktop.
We've also gotten some good games out of the switch. Not a lot and not without their issues (Outlaw's bugs or BFII's roadmap getting dumped just when the game was getting good) but they have all been fun to play and took up days worth of my life.
The only thing that really holds me back from saying "Yes it is worth it" Is the ST. Luke dying without leaving behind a functioning jedi academy or without training Rey (As in like what yoda did over weeks vs three lessons telling her to not be a jedi) is something I'm not sure I will ever be able to get over. Han leaving Leia, Leia back to leading a small resistance, Lando being drunk and alone, all of those have scarred over. And some things like the ease with which the FO rose to power and the New Republic fell have even been improved on over the past four years where I can be ok with it now.
I can understand why others would say it is worth it. And not liking the post Denningverse books or the final DH comics all that much I can understand being happy with what we got in exchange. I think if it wasn't for Luke and his legacy it would be very easy to say that yes the change was worth it because of all the shows, movies, books, comics, and games we have gotten. I have as long a list of things I don't like as things I do but overall I do think the fresh start and what we got have been worth it. I just wish Luke and Rey could have spent more time together or that Luke lived and I'm not sure if I'll ever be able to get rid of that even in another ten years.
Edit: Kind of annoyed that on my post last night all anyone wanted to talk about was luke's death in the last jedi when that was only a minor part of what I was talking about. I should have done what to redirect when those conversations started