@Spooks I feel your pain. I’ve had the same experience in August 2019, minus the unconscious part. Broke my left hip, badly, on the first day of vacation and then spent 8 days in hospital before being flown home.
My hip was “fixed” with a gamma nail.
Here we are 1 1/2 years later and I’m cycling again, preparing to ride a few Gran Fondos in the summer. I’m also running, doing yoga and strength training. It’s not perfect yet, as I still have some flexibility issues in the hip and some aches now and then because my running pattern is not exactly what it used to be. But, and this is the main thing: I’m improving and I’m sure that my cycling can be just as good as before the accident.
During the recovery phase, I spent a lot of time at the physiotherapist. Find a good one that can help you get better. In the beginning I needed lots of training to get out of bed, get up the stairs, walk (on crutches) around the house. After a while it went to weight lifting, (slow) running, jumping, etc. Sometimes there are setbacks, often there are improvements. Just be sure to remember the improvements and not take them for granted.
It’s hard work, mentally and physically, to bounce back, but as cyclists we’re used to hard work, so I’m sure that you can do that as well!