Everyone will differ in their opinion I'm sure, but my favorite spot is in the circle near the entrance, near Roy Disney's statue, essentially in a spot with a full view of the castle. I think it's great from a pure visual standpoint, but it also has the advantage of being close to the exit once it's over.