I've only really ever played Pathfinder (I forget the version we played), and DnD 5e. The types of campaigns I like to be part of are really fast-and-loose numbers-are-a-suggestion type heavy on the storytelling and roleplay. I've played some amazing campaigns, and I love sharing all the crazy stories.
One fun one that comes to mind is a 5e campaign which was anime mech fighting high-school themed... I played a "warlock" character who was a deadbeat street thug who schmoozed and lied his way into the academy to try and move up in the world even though he had no mech fighting or other relevant experience, and my patron was a significantly older otaku who would channel their years of expertise through me via sat phone/an earpiece to pilot the robot. Out of everyone in the campaign, I had the smallest, weakest weapon, a simple dagger, but I was able to manipulate the images reflected off the dagger's blade and did most of my damage and combat via psychological warfare and manipulation (which were canonically things that I had tons of experience with from my time on the streets). I ended up getting like full-mech active camo as a logical extension of the blade-reflection-manipulation and went towards a stealth build which was fun.
After all the people I played with all moved away and we stopped playing, I tried to go to a game store and find a campaign. I found some people who were looking to start something, and I built a Kenku alchemist/rogue with a whole tragic backstory with a bunch of various villains I gave to the DM if they needed anything to tie in. I 3D printed a bunch of little percussion instruments, made a custom not-obnoxious utility sound-board on my phone, and even made a custom Guiro with differently-spaced ridges that the sound of was supposed to be my "real kenku name"... Nobody cared, everyone was annoyed at my insistence to be thorough in roleplaying, the wizard was a min-maxing Timmy rules lawyer who's only character trait was "Hat that slowly gets bigger without you noticing until it's a really fucking big hat", and needless to say I only played like 2 sessions lol