I've played a good number of TTRPGs. I tend to lean towards more story-focused rather than mechanics focused games and systems. Here's some of my favorite games I've played (not counting one-shots).
An extended Monsterhearts campaign (WE NEVER GAVE THE CAMPAIGN A TITLE, OOPS). I play Narcis, a vampire who tends to get very stressed and make bad decisions, who right now really wishes they were normal again. Really really love this group. Lots of "play to lose" energy, characters with really dynamic and interesting growth, and very fun conversations. Definitely the highest density of gameplay time consisting of the players just talking to each other in character out of any campaign I've played.
Takes Time to Rise (FATE)
My long-form FATE campaign. I originally intended for a more serious campaign, but the silliness of my players forced me to adapt. Plot is as follows: a deeply unintelligent former monk (Marx Knightly), a former mafioso clown (Stubby Pat), a linguistic knight sorceror (Gladys Uriath) and a sentient bunny plush (Theo McFluffykins) accidentally unleash a moss that absorbs magic (used to power all major infrastructure) onto the world during a baking competition.
LOTS more detail here.
A short and sweet (7 session) DND campaign I ran about some folks travelling up a mountain. Really good synergy between my players, perfect balance of silly and serious, methinks. Each session focused on the backstory of a particular character. My first time every DMing DND! My evil DM secret is that I ended combats whenever I felt like they were going on too long, I did not keep track of damage at all, which is why I'll probably only DM other systems in the future, ha ha.
Probably the most serious campaign I played? Like, I really felt all our characters all had depth and real relationships, it was very fantastic. Our DM said that this was the only game they've ever run that wasn't complete nonsense, which I think is funny. This system is about playing as a team of young superheroes, and it worked really well. I played Doohickey, an tinkerer, who was the son of a supervillain called Doodad, who was one of the main antagonists. This is my favorite pun I've ever made.
Out of Time
A friend's DND campaign, set in space and involving time travel hijinks. Played as an Aarakocran space-cowboy flamingo. And I was usually the voice of reason, obviously. Lots of thoughtful and detailed worldbuilding. Never got finished b/c of life getting busy. Ah, scheduling, the greatest enemy of any TTRPG group... foreshadowed in the name of the campaign...
Lovely's Natural Solutions
A friend's Call of Cthulhu campaign. Taught me that actually, 2 hours is the ideal length for playing a TTRPG when remote. I played the Mayor of Fresno. An eldritch something-or-other forced I and the other PCs to work together to do various tasks. My character eventually lost the ability to feel emotions. The best part was coming up with weird lore for the fictional version of Fresno. One player made postcards for the Fresno Spike Pit and sent one to each of us. He ended up with lots of extras, so he sent them to random people. Here's ProZD reading one.
My first big campaign! (technically I had played a Pathfinder campaign before, but it sucked b/c half the players wanted just a grindy-mechanics focused game and the other half only wanted story, so I don't count it.) Played a Tabaxi bard. Our DM was a master-class storyteller, they narrated and performed each character in such an immersive way, I can still visualize so many of the settings. Something I always struggle with when DMing is describing locations, but they always nailed it.