Just to update on the above post, I tried Crucial advice on their website saying to connect the SATA power only for 20 minutes, disconnect for 30 seconds and repeat one more time, but without any luck. I even tried again but for 25 minutes and finally two sets of 30 minutes with a minute off before, between and after.
That's when I dug up the order to try creating an RMA. As a final attempt, I connected it back to the USB to SATA adapter with the power cable plugged in and this time left it sit for roughly an hour. I then connected the USB lead and it popped up! Just in case it would not power up again, I copied off anything was not recently backed up and then put it back in the laptop. It seems to working fine now and I've updated the firmware.
So for anyone else with an SSD failure, at least a Crucial brand, it may be worth connecting the power (without the data cable) and leave it sit for an hour or two.