Thanks for everyone's input so far.
Progress..
I attached a battery boost to the car yesterday, started it..and she started up and ran well.

Left the car idling whilst i disconnected the battery boost and it ticked over with no problems. All the warning lights and MIL lamp went out.

Keyed off, keyed on and...click..nothing.

I checked the engine earth and it was secure. I had a good resistance and continuity to the battery negative.

For info the engine earth is on the front of the block, bottom passenger side (RHD) just behind a pulley (Can't remember if it's aircon or PAS) on my 2.5 v6
I repeated the battery boost test several times and it was fine all times. I think i'm going to get a new battery..
I don't know if the starter motor was faulty because apparently these you can't bench test and the replacement showed the same symptoms.
Moral is check the battery before the long tedious and arduous task of changing the starter motor.