The ballroom scene in "Beauty and the Beast" is so elegant and straightforward, it always gets to me. Seconding about the feeling on the last day of vacation...it's always so bittersweet. No one ever wants to say, "ok, we're done"!
(For non-Disney, can I geek out for a moment and say series 3...