Do check out FreeSpace Source Code Project[0]. They've upgraded the code and assets to make the game look great on current machines. AFAIK it still requires the original game for the Single Player campaign (easy to obtain through GOG).
As for mods changing things, I highly recommend Battlestar Galactica: Diaspora Mod[1]. It's even better than it looks on the promo[2], and you can do most (all?) of the tricks Vipers did on the show. And you can fly a Raptor too. Single Player storyline is well made, with great voiceovers, and doesn't break continuity with the show.
Oh, and I totally second 'Fjolsvith - FS/FS2 is the best space combat game ever!
--
[0] - http://scp.indiegames.us/
The dramatically increased spatial awareness and FoV is also useful. I find myself sticking to ships with massive cockpit windows, because I look up at them all the time.
Pity about the resolution, that's all. VR right now is good enough to use... but it'd be so much better with about twice the linear resolution.
I'm currently into Star Citizen, Elite Dangerous, and have also backed http://starfighterinc.gamepedia.com/Starfighter_Inc_Wiki which looks really promising. Oh and Eve-Online, however that's not first person as such.