Somewhere on Main Street, in front of the castle. We watched it 3 times from there and once from Frontierland and you just don't get the same effect unless you're in full view of the castle. It'll be crowded on Main Street, but you get the full effect of the show from there, plus you can see the special effects on the castle.