Well, an update on this situation.
FreeSpace 1 main campaign, I managed it through using my 360 controller with the roll axis on the right stick the wrong way up, but I did use Xpadder to map the correct way to digital roll via the numpad keys. It also meant I could add a vibration to the afterburner button which was a nice touch.
That said, the control wasn't ideal as aiming was a little off at times, and the Silent Threat expansion was just seriously annoying me on the first mission, which I just couldn't do in time.
As such, FreeSpace 1 got uninstalled, and I moved onto FreeSpace 2, for which I'm using FS2Open 3.7.0 and the MediaVPs. Have to say, it looks great. Oh, it doesn't offer any improvement in support for 360 controllers. It seems to still be DirectInput, not XInput, so the wrong axis mapping still carries over.
So, tried playing FS2 with the 360 controller but something wasn't quite right, so instead I tried the mouse for aiming. Had to move the sensitivity up to the max but once that was done it does give a nice steadier and easier aiming experience. Because of that I then unplugged the controller, removed all the key bindings for the controller and set up the mouse to play, learning many of the targetting, weapon and thrust keys. To aid just that little bit more I also set up a GlovePIE script to enable me to use the two extra buttons I have on my mouse, one of which when held makes my left/right motions with the mouse roll instead of turn, the other to cycle secondary weapon firing rate.
So yes, I've now moved to a mouse and keyboard control system. Going to have to give tinyE the solution as first to say mouse and keyboard :P. But all the different programs, Xpadder, MotionInJoy, Pinnacle, Joy2Key, just aren't set up to do what I need without using an additional program such as PPJoy to set up a virtual DirectInput device to map to, and PPJoy doesn't have signed drivers for 64-bit yet meaning I'd have to disable the signed driver requirement, but two programs and this just seems like too much work for such a simple requirement.