Thank you @crunchermuncher and others who made comments like this.
I am home now, told to take it easy and go straight back if any further episodes. I will get a follow-up appointment in the next couple of days and I have a maternity appointment on Wednesday just to make sure everything is OK with baby.
I've never had an overnight stay at hospital apart from having my babies, it was certainly an experience I don't want to experience again anytime soon.
To all the commenters, who commented things like your ok, you've been triaged and assessed, your on your phone etc. You were not present at my triage, things can be missed, due to many factors. I clearly wasn't triaged thoroughly. I was not spoken to by a nurse at the hospital. She only spoke to the paramedics. Only my BP, HR and temp was taken. Once in the whole time I was waiting. I didn't have a blood test until I was seen by a doctor and I didn't have a urine test at all. I repeatedly asked for water, none was ever given in the whole 2 days, but I was pointed to a vending machine only containing fizzy cans. I repeatedly told them my stomach was hurting, this was not an exaggeration, I suffer from PGP and in the end I could barely stand up. The doctor had to lift my legs onto the bed. It was extremely embarrassing. (Thankfully) DH arrived shortly after that and was able to help out.
You and I don't know why others were there, so we cannot assume who was in a worse position, however, people were seen 'first come first serve' from what I could see. A lot of people were transferred to the walk in centre at 7am and this afternoon when I left, the wait time advertised was 90 minutes.
I understand the pressure nurses and doctors are under, but there should be access to water and arrangements in place to offer those in need a padded seat.
I think this was all down to a mixture of cut backs and the way the hospital is run. Obviously I have attended A&E before in my life. I am aware there are long waits, but this time was just shocking the way I was spoken to and treated, when this is the most serious of symptoms I have ever attended with before in my life.
Sorry for the little rant above, but after reading some more of the comments, some are very upsetting.
But once again, I really thank those who left kind comments, it really means a lot to me, it really cheered me up when I was in there.
This will probably be my last post now, I'm usually a silent watcher on mumsnet, but I will update if any significant updates that may be of use.
I have also researched hemiplegic migraine, as many suggested and I think this sounds very similar to my experience. I will probably bring this up with the neurologist in the next few days. I appreciate those who have let me knkw about this kind of migraine.
Good night everyone and happy weekend, hope you all have a good New Year, I will certainly be spending it on the couch with some nice chocolate! X