Others have mentioned Wesnoth, Oolite, and Cataclysm: DDA, but Angband and all of it's variants hold a special place in my heart. MAngband, ZAngband, TOME, all drew countless hours from my youth. FreeCiv is excellent. I think the name has changed (or it's been forked?) but Tremulous was a lot of fun.