When it comes to multi-player games the only decent ones that I've ever liked were SWOS, The Settlers & Archon...
I'd have hated for all my SNES RPG games to have been multi-player, these games are best played on your own as you get so involved in the story and mission that having to rely on playing against someone else who may lose interest along the way would have been awful...
Multi-player games have their place but to say almost all games should be like that is just daft... sometimes just taking turns each at games like Deluxe Galaga to try and beat the other persons high score is the best way to go, games don't have to be multi-player to make them enjoyable...