I'm still a frequent Star & Freelancer player, so Star Citizen basically sounds like one big joygasm to me! I just hope it's as good as it seems on paper and that it has the same longevity as FL.
I'm even speccing up my new machine based on this and Elite: Dangerous.
Can anyone recommend Freelancer single player mods? Perhaps maybe some graphical mods? I see some on moddb, but not sure which ones are any good.
Start by grabbing the Freelancer Mod Manager. That comes with a few already included. Most Mods run through FLMM.
From there, it all depends on what you want modded. Many servers have their own Mods, which may or may not include alterations to the Single Player, but check which ones they allow if you go online.
I *believe* the award-winning Crossfire Mod is the most epic one, where not a single thing remains untweaked and it greatly expands the original SP as well as online play.
Hamburg City is one of the most popular servers and they have a Mod. They're also pretty hardcore players. Speaking German helps, but isn't essential.
Discovery has one, or several, or lots, depending on who you ask and which of their servers you play on. They have LOTS of ships and mods and bits and pieces and things and stuff... There's a debate as to how well/badly balanced it all is.
For simplicity - Freelancer Universe aka FLU.
My favourite server, been up 24-7 since 2003 and while this has it's own Mod (minor things like commodities, ships and a few extra systems, with balances fairly good and always being refined), it will still work perfectly fine for vanilla Freelancer.
The people there are very friendly and helpful to talk to but it's quite an aggressive PvP culture, as in they're always up for combat. Newbies are given lots of assistance, though and you'll get more PvP in 3 days there than you will in 3 months on other servers. Worth noting that there are NO 'safe' systems - Expect to get shot... a LOT!