I really like the Star Wars universe, but the only good new movie was Rogue One. It worked because it was a completely separate story only loosely tied to the original films.
Personally I love both anthologies, and I love them a lot more than the new trilogy (I love Luke's role, but I have doubts about where the trilogy as a whole is going). I know Solo bombed, but for me it was the movie I'd been waiting 30 years for, and I wasn't disappointed.
That stuff takes balls, and I'm enjoying it a lot.
It's true that superheroes do dominate the current movie landscape maybe a bit too much. Nerds won and now everything has to be SciFi, Fantasy, Horror or Superheroes. I wouldn't object to dialing that back a bit, but only a bit.
There are at least a few of us out there who think the same as you. The one difference is I haven't watched one in the theater in years.
For the Legends storyline, I loved the X-Wings series of books (basically how the Rebels defeated the major parts of the Empire): https://www.amazon.com/dp/B01BJST00W . My favorite book in the series is The Bacta War, there's a lot of small ship action instead of the movies where huge fleets are the norm.
Also in Legends, try the Thrawn trilogy starting with Heir To The Empire https://www.amazon.com/dp/B004WBXM80/ . It's a good set of books with a real threat to the Rebellion.
As for Disney canon, frankly a lot of the books are very meh at best - many of them are just to set up Disney World/Land Black Spire Outpost land. The only one I would recommend is perhaps the new Thrawn trilogy: https://www.amazon.com/dp/1101967021/ - be warned that the second book in the trilogy (Thrawn: Alliances) gets rather slow at times, but the third book (Thrawn: Treason) is actually pretty fun.
Another X-Wings fan! Bacta War was awesome, I must've re-read it like 10 times :-D
The first 3 star wars films where important for their era, but most of the later ones are just forgettable sci-fi (for non-discerning fans). Not to mention letting down parts of the canon (e.g. the Solo movie, or "Kylo Ren", a hipster/teenage goth abomination that took Darth Vader's iconic status and pissed all over it).
Marvel too has movie diarrhea, with 1 in 10 movies being anything to write home about (eg. Logan).
I'd vote for less superhero movies and less Star Wars reboots and sequels/prequels, and more original stories. Plus, where's that Foundation series?