Any good PC games with a good campaign?

I don't want anything that is an MMORPG style. Just something that has a good campaign. Good graphics, nice storyline. I enjoy FPS games, as well as RPG. Sci-fi and fantasy would be ideal game-types. Thanks :)