Just tried a cheap Serial to USB adapter and it works but i'm hitting a brick wall, drivers wont load.
Of course they won't. What you have is still a serial device, even if you connect it to the PC using USB to serial adapter. That generic adapter won't magically translate the protocol to HID or whatever the USB version of that joystick uses.
I went back to the drawing board and though about it again, everything online refers to this wheel as a USB wheel and doesn't mention serial and sure enough this wheel would have came with an adapter cable.
Be very careful, it is very common that the same product existed in two versions.
Once i get my hands on sacrificial db9 Serial Cable im going to make the cable as per this pinout that keeps being mentioned
(Attachment Link)
Uh beware! Better check voltages on those pins before you connect anything to the USB port of your computer. If the wheel has only regular RS232 connection, some of those pins may have +12V or -12V on them (they are normally used for flow control and various auxiliary signals) - that will reliably destroy your USB port and/or motherboard if you connect that passive adapter there.
If you want to try this at least use a sacrificial USB hub and don't connect things directly to your PC - it is better to blow a cheap hub than destroy the motherboard should anything go wrong.
BTW, you don't need to get any "sacrificial cable" (the cable will likely have wrong pinout anyway, many cables don't have all those extra pins connected), just buy a DB9 connector and solder those 4 wires in place.