Well, S:TE is 415ft tall, but the cars don't usually reach anywhere near that high.
Like Craig TCF said; bigger isn't ALWAYS better now is it??
I mean, for me, two awesome examples would be Villain and Exterminatior. Both are in my Top 10 list. They weren't record setters, they are just downright fun.
Personally, I felt like MF was a let down. 300 feet is great, but the ride needs to be FUN. Magnum is FUN. I will admit to being in love with Magnum. But, other than that, bigger has never been better for me.