Yeah me too, i was shocked when i was reading the thread's title. But VGX is coming so... who knows? maybe we will see new fallout sooner that we expected.
Try following series:
Max Payne,
Just Cause,
Assassin Creed,
Batman,
Splinter Cell,
Prince of Persia,
Tomb Raider,
Hitman,
Mafia,
Sleeping Dogs,
Prototype,
Devil May Cry,
Saints Row,
GTA,
and LEGO of course :P
edit: Mass Effect! how can i forget about it :<
Hard to find nice SP mode in shooters nowadays...what's a pity. I will never buy expensive game only for multiplayer. Network playing is amazing but sometimes i just want to sit on my sofa with beer in other hand and play some single (pause mode <lol>) :)