Looking for a FPS with a good single player campaign. Suggestions?

[Parasitic]

You heard Half-Life is pretty good?! What?! It's more than good. Get Half-Life 2 and all the episodes, they're great.

HL2 also has a rediculously large modding community backing it up.