We had the best view right at the bottom of main street right next to the flag pole. Other people say that the best is at the entrance to tomorrow land because she goes right over your head.
I like bottom of main street becasue you can see the whole castle and the effect to me is amazing. Plus if you want to make a quick exit after then you can as you are right next to it.