Just Cause 2
then some more Just Cause 2 for good measure.
Other people have also said Mass Effect, which really isn't a first person shooter either.
Now that i've got my trolling out of the way, time for my recommendation: rouge warrior.
I know it's rated pretty horrible, but I actually had fun with the single player campaign. I'd say just as much fun as I had with any of the cod single player campaign's. Plus Mickey Rourke's one-liners are great!
Edited by anubis1127 - 2/12/11 at 11:18pm