I'm a bit jaded cause I work at a venue (the Fillmore) and see TONS and tons of concerts, but I do have many many moments that get me all worked up...
Morrissey last year in Reno Nevada - I've Changed My Plea to Guilty - a song I don't think I've ever heard live but it got me misty! (If he had done Now My Heart is Full that surely would have done it)
Tindersticks at the Fillmore about 10 years ago and then more recently at Bimbo's (2004?) - basically the whole show.
Depeche Mode in San Jose 2005 (not sure if anyone here likes DM) - when Martin came out and sang 'Somebody" with just the piano accompaniment - I totally lost it cause that song holds so many memories of my teen years....
Seeing Tom Waits (with the Kronos Quartet) finally for the first time last year at Neil Young's Bridge School Benefit - I had been waiting SO LONG to see him he could have sang Christmas Carols and I would have been happy! He sang this anti-war song that was so moving you could have heard a pin drop in that ginormous venue!
RH at Cafe du Nord last year - the whole show but especially when he did Valentine!
Coachella 2004 - Seeing one of my favorite bands the Pixies reunite, then Belle and Sebastian THEN Radiohead all in a row out in that hot sweltering desert. Magical!
that's pretty good - I think I'll leave it there!