The only attraction that makes me uncomfortable now is Its Tough to be a Bug, especially because of the giant spiders that (i'm convinced) are going to grab on to my head. Of course, I get the good kind of scared at ToT (my favorite attraction ever) and Space Mountain too.
I remember when I was a kid (4-5 yrs) I threw a fit because my dad wanted to take me on Space Mountain (I was a tall kid, so I met the height requirement). He had to drag me to the entrance of the ride, where we saw a sign that said it was closed for rennovation at that time. I remember being so relieved. Of course, the next time we went, I rode it and loved it, and still do.