You'll have to trust me on this one anyway.

FS2 is too fast to really see normal maps very well, as you usually don't see the fighters very close.
And you may have noticed that the capital ship maps aren't that extreme.
It may not be the best way for screenshots, but it's most likely the best way for graphics during the gameplay.
Also, FS2 is a rather colorful, effect-extreme game. Big glows, big beams, huge vibrant nebulas, ect.
I simply think it wouldn't be right to go for a too realistic look now.
(And yes, I do like Howard Day's models anyway.)
the best way seems to be doing a new low poly mesh, then building a very high poly one and bake the normal map onto the low poly one. Its a lot of work but looks more "real" instead of added on.
Yes, a lot of work. Especially with already triangulated models (source files, anyone?). I'd eve say it's too much work to justify the work.
And baking sounds so easy, but it's actually quite painful to fight with the cage. You often end up with stretched details, which really don't look 'real' in any way. So you need to take your time for the baking too.
I will do it for one model later, but that's it.