Lots of film make me choke up, but can't think of any moments in Trek that elicit the same.
But...the episodes/films/moments I find most moving are:
TWOK (esp. Kirk's last lines, looking at Genesis Planet)
Janeway & Kes's last scene in her ready room (The Gift)