OK, anyone who quotes "Adventure is Out There!" is cool in my book.
I'm kind of a ride wimp, myself, so I get where you're coming from. I like BTMRR, but once a trip is enough for me. I LOVE Splash Mountain! I'm not picking on anyone, but I hear so many comments on how the drop looks so scary, and I get that, but it's really not, it's fun! Maybe it's because I have ridden and loved flume rides since I was 5 years old, but I've never been scared of Splash, and it is such an awesome ride with the story and songs and so much fun. For years, people rode it with no lap bars/restraints, and Disney finally put in the bars just to deter rider foolishness (standing up, etc.). You can stand by the fence and watch the logs coming around the stream after the drop; you'll see plenty of people laughing and having a wonderful time. Just tell yourself you can do it, get in the line and give it a try. If it's not your cup of tea, you don't have to do it again. If you like it, you will have to do it again to catch all the inside story when you're more relaxed. (Do be aware there are a couple of small drops in the dark inside, but they are quick and short.)
Expedition Everest - OK, I refuse to do RnRC or Space; I've done TOT but not for a long time, and I'm iffy about doing it alone for whatever irrational reason. But I'd always really kind of wanted to try Everest, and I finally did it this year. It was super-scary, but kind of fun. I can't decide if I'm going to do it again next year, but I'm really really proud of myself for doing it (bought me an EE cap afterward as a memento). Backwards in the dark was not as horrible as I feared (didn't make me sick or anything), but I'm glad I was prepared for it. It DOES make you feel like you're going upsidedown. The scariest part to me was an unexpected forward drop in the dark (I think it was only one, but... ?) The big drop out of the mountain wasn't as bad because at least I could see what was coming. The EE drops felt steep to me (felt MUCH steeper to me than Splash, FWIW). Going through the EE single rider line was a huge help to me because it was practically a walk on, so I didn't have time to get cold feet. I'm really glad I did it, and I can't swear I wouldn't do it again, but for a "ride wimp," it is pretty scary. But you'll never know unless you try!
Just my opinions.