Oh gosh, I don’t think I can do a proper overall ranking. I can definitely rate by group, though. Here goes:
Original Trilogy
I was born in 1981, so I grew up watching these on the small screen.* The Empire Strikes Back has always been my favorite, though Return of the Jedi is good too. I do like A New Hope, but I feel it hasn’t aged all that well compared to the other two.
OT Ranking:
1) The Empire Strikes Back
2) Return of the Jedi
3) A New Hope
*I did see the Special Editions in the theaters. While they are mostly abominable, I somewhat surprisingly find the ESB version to be fairly palatable. I think you could argue that it's because ESB is so close to being perfect that even George Lucas couldn't ruin it!
Prequel Trilogy
In 1999, I was fresh out of high school and super-excited at the prospect of finally getting to see a brand new Star Wars film at the theater! Well ... let's just say, for only the second time in my life, I found myself wanting to walk out of the theater in disgust. (The first time had been the year before, when I went to see Van Damme's Knock Off. In hindsight, it would seem I was a bit of a masochist in my late teens.)
I hated The Phantom Menace so much that I didn't bother to go see the next two prequels at the theater. In fact, I didn't watch either of them until years later. I agree that Attack of the Clones is hands down the worst of them all. The fundamental wrongness of Anakin and Padme's relationship aside, the movie is just one long snoozefest. Even the action sequences are boring. (Although, unlike [MENTION=6716779]Zardnaar[/MENTION], I enjoy Yoda’s Sonic the Hedgehog impressions!)
Revenge of the Sith, on the other hand, is a noticeable improvement. Still not as good as any of the originals, but good enough that it’s the only one of the prequels I have on DVD. I like the novelization even better. It’s surprisingly well-written and does a much better job of making Anakin’s fall believable.
PT Ranking:
1) Revenge of the Sith
2) The Phantom Menace
3) Attack of the Killer Tomatoes Clones
Sequel Trilogy
I like The Force Awakens. I don’t mind that it’s essentially a reboot of ANH. I don’t mind that Rey is a bit of a Mary Sue. I *do* mind JJ Abrams’ complete disregard for the vastness of space (something that irked me about his Star Trek reboot as well).
I also find Disney/Lucasfilm’s unwillingness to answer most of the questions posed in TFA frustrating. I don’t mind that TLJ had very few answers in it (although I did at first) but they won’t even give us the answers by other means (eg. novels, visual dictionaries, etc). Is Starkiller Base the planet Ilum? I want to know! Enough with the teasing!
I have come to like most of The Last Jedi as well. I think there are some parts I won’t ever like, such as the lengthy space chase and Leia’s Mary Poppins impression, but there is still lots I do like about it. All the porgs, for instance.
I am curious to see whether Ep IX can wrap things up satisfactorily.
ST Ranking:
1) The Force Awakens
2) The Last Jedi
Star Wars Stories
Rogue One is awesome and may even be my second favorite overall after ESB. I feel it does a great job of capturing the feel of the original films, and I love that it's essentially a Guns of Navarone-style war movie set in the SW universe.
One sad thing for me, though, is that I feel like the dramatic impact of the Rebels’ sacrifices in Rogue One is cheapened by the fact that, a mere thirty years later, we’re right back where we started with the galaxy under the sway of a tyrannical empire.
I also really enjoyed Solo. Its dismal box office performance made me sad, especially because, after Rogue One, I was looking forward to a whole slew of stand-alone Star War stories. I wonder if we’ll ever see anymore.
TV Shows and Other Media
I think I've seen all of the Clone Wars stuff: the "movie" (which is literally just a bunch of episodes strung together), all six seasons of the show, plus the original Tartakovsky series. As others have said, there's some really excellent stuff there but also some real crap.
I haven't seen all of Rebels yet, but I've enjoyed everything I have seen so far.
I'm cautiously optimistic about the announced Cassian Andor and Mandalorian live action shows. I'd like to watch them but I'm not sure I'll be able to, since they'll be behind the Disney streaming paywall.
I've only read a small smattering of SW novels and comics, most of which are no doubt apocryphal "Legends" now. Most of the books were rubbish, with the exception of the Revenge of the Sith novelization. That's a real gem, right there.
In terms of video games, I started to play KotOR once but found the UI too clunky and never got off the starting planet. I think that was the only one I ever tried playing.
I also used to play SWSE and still have all the books. The game was fun at first but eventually its mechanical flaws got to be too much for me. I don’t think the d20 system is a good fit for Star Wars. I doubt I’ll ever play it again.
The only other thing I'd like to say is that, as a father of three daughters, I appreciate the effort Disney has made to include more strong female characters in the franchise. Some of them are definitely better role models than others, but I’ll take them all over Barbie and her sisters any day!