Agreed it needs something. I'm reluctant to buy a decent set of coilovers if the ride is going to be just as hard, same problem still if I buy some Uprated shocks what's to say I won't still be in the same position.

I'm just after a general consensus as to what my best option is as its definitely not a pleasure to drive at the moment and I want to get it sorted once and for all

I have the Bilstein sport shocks and H&R spring (x-drive if that matters) and while the ride is stiffer then the stock suspension it is nowhere near unbearable. Maybe just go back to stock suspension if you liked the feel of that better. Any lowering option is going to compromise the ride quality to some degree.

If you want to use your H&R springs and save some money just go for Koni Yellows. You'll find them to be a nice compromise. The reason your ride is so spine jarring is because your shocks are probably bottoming out or you're nailing your bump stops. KW makes coilovers that are centered around comfort that you could also take a look at. Any coilover is going to be more forgiving than bottoming out/blown shocks though. Mine felt more compliant than my stock nonsupport suspension before they blew on me.