Alpha Centauri is the only game of the whole genre I could get into. The SF setting, the faction leaders and their personalities, voiceovers, music, atmosphere... That game is basically my reason for installing wine and playonlinux.
Alpha Centauri has a Linux native port though! I'm not sure if it's still available somewhere however (there's probably a torrent somewhere).