It's not for FPS's (although it's been used for that), but Starcraft 2 has really impressive modding features. I've been third person action games, arcade shooters, 2D platformers, and tower defense titles. There's even a popular soccer game where each player is a unit from Starcraft.