A song that always picks me up and I always end up singing along with is "No Rain" by Blind Melon. Another song that always has an affect on me is "November Rain" by Guns N Roses. Ah, to be a young, depressed college student again.
Two that spring to mind: Joe Mantegna-some dad started taking his kid out of the audience because they thought it was going to be Joe MONTANA. Mantegna takes the kid aside and tells him to take a seat or he'll have things done to Montana.