I haven't been to SFMM for a very long time, and only twice in my life, and doubt I'll ever go back. The last time I felt more punishment than pleasure on too many of the coasters. I declined a second go on Viper( because of that stroke or aneurism kind of fear) when my younger husband wanted to go again. And I'm at a high risk of stroke because of a heart issue, though I didn't know that at the time.
I do think that extreme g-force in amusement rides is a legitimate concern. My brother and sister-in-law took their family to WDW during the soft opening of Mission Space, and were selected to ride. My Sister-in-law's inner ear didn't react well and she spent about a week feeling disorientated afterwards. It seriously affected the rest of her trip. I think(?) they turned down the g-force "volume" before the public opening, and her experience may have contributed to that. At least that's how I heard it from them.
Apparently, I'm not the guy to help you get over it. Sorry man.