Not all of them. Guild Wars is excellent in PvP. Also, Counter-Strike is an excellent multiplayer shooter. It isn't based on a storyline, it is just a shooting FPS that anyone can enjoy.
TF2 is also extremely fun. If you're going to bitch about the newer games, keep it to yourself. I own TFC, and I will say that they are both respectively different to play.
I recommend:
Starcraft,
Diablo 2 (Diablo 3 is coming out soon =D)
Battlefield 2 (2142 is pretty gay, don't bother with it)
TES3: Morrowind
TES4: Oblivion
These will keep you entertained for a long time, especially the last two. TES games have many long hours of gameplay, and you can do so many things in so many ways. They are single player, but good, and you can download mods (thanks to the construction set), which are generally under a megabyte each, but can really change the way you play.