Great thread topic idea @Scarlet Shocker!
I logged in to City of Heroes for the first time in Issue 0, early 2004, but actually stopped playing CoH before sunset and didn't know about the game closing until years later. To answer your original question, I haven't stayed in any one similar to CoH gameplay genre, but I went through many games since legacy days:
RPGs (The Legend of Dragoon [many times], Final Fantasy X and XV [many times], the Kingdom Hearts series, Conan Exiles [currently], and Star Wars Knights of the Old Republic (many times)).
Survival games (No Man's Sky, Satisfactory, Stranded Deep, Ark, Conan Exiles (double tap for multiple genres), The Long Dark, Subnautica, and Raft).
Action/Adventure games (Batman Arkham series, Tomb Raider series, God of War series, Assassins Creed series, A Plague Tale series, and Firewatch).
Strategy games (Civilization [every Civ game 3 and after, but I love 5 the most!])
Shooters (Master Chief Collection, Halo 5 and Halo Infinite [😢])
Edit: I know I'm missing some, but that's what I remember at the moment. I also did a lot of living (undergrad, married, military, grad degrees, busy career) between when I stopped playing CoH and when I started back up in 2019. And I discovered I like running a lot, so that is my main hobby outside video games.