I had a 7800 and an x86 PC concurrently (before that a c64). At the time I sort of loathed not having different console, but now I look back wanting to recreate my whole library. There's been many discussions on AtariAge about whether or not the 7800 could have handled a Super Mario Bros. platformer, and the consensus was generally yes.
Here's the cool thing about the 7800. NES games were about $30-40 back then. 2600 games could be had for $3-5 at that point, and 7800 titles eventually dropped to like $10. You could get a new game or two (or three) every week as a kid, and I feel like I benefitted from playing many pioneering console games I might have missed otherwise.
At least I still have a badass Lynx and Jaguar collection.