In Civ 4 at least, the Beyond the Sword expansion really added a lot value to democracy and espionage in even single player games. I'm hoping that in Civ V they'll have an even more significant impact on the game.