I own a Super Nintendo as well as a Super Nintendo Classic that I added more games onto. They are definitely fun to play and there are some hidden gems but playing on the normal Super Nintendo can be kind of annoying when looking at how quite a few SNES games have weird controls.
I remember the days of N64. I think it's really nostalgic to play those games in some simulator now a days. I know for sure that many also enjoy playing those simulator games in android phone too. I am sure the same feeling would come once the Switch and Switch Lite become retro in next decade.
Not including handhelds here, but... I was not able to get my own game system until the GameCube, which was a few years after it was released initially. A few years later I got my own N64 and a bit after that, a Sega Genesis. I also played some of my extended family members' Segas, N64, SNES, and NES a few times growing up. I've definitely got some experience playing some of these retro consoles, but I don't have a huge array of games in my knowledge. I only have a couple of games for each system and haven't played any of them super extensively (with the exception of Columns 3, Sonic 2, Pokémon Stadium) though.