We got a 7800 in the 80s because it was backwards compatible with the 2600
The few 7800 games that I played were stale arcade ports such as Ms Pac-Man and Dig Dug. The controller was not the most comfortable either. I really wanted a NES which had a much more exciting selection.
Granted the 7800 is superior to NES in some ways but as with the Sega Master System it couldn't compete in terms of games. The sound also sucked unless the cart included a special audio chip which I think only a couple games had.