The illest I've been would be the explosive decompression associated with food poisoning.
The most scared I've ever felt due to illness was the one and only time I believe I've had a migraine - I got a bad headache, and started to get occular involvement after a couple of hours - became totally affected by sounds and smells and nauseous, so signed myself off, and began the drive home - teeth clamped against the incipient vomit I felt was coming.
Half way home, I blacked out in one eye, and the headache became piercing. I pulled over and threw up, then slept for an hour in a layby before driving home still with one eye.
24 hours sleep, serious pain meds, and I was fine. 8 years later and it's not happened again, so I think it was stress.
The most miserable I've been was when I got the noro virus a couple of years ago. We'd been going through an IVF cycle, and went to the hospital for implantation (took all day). 2 hours late, we left the hospital, with JUST enough time for me to get home in time to pick our daughter up from school provided we didn't stop. We had 1 hour for a drive that takes 1 hour 10.
About 10 minutes into the journey I feel the need to vomit.
We made it to a petrol station where I got some water, some plain crackers, and was sick.
Back on the road (and certainly late) I drove in 10 minute sets, pulling over the throw up every couple of miles. After trying everyone we know on the phone we managed to raise the childminder to get the girl from school, and my dad to go and collect his granddaughter from her after work and keep her overnight.
In the end, the journey took four hours (counting a 40 minute stop on a park bench mid way).
The worst thing was that the IVF failed, and I have never stopped wondering if the stress of that journey was contributory.