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.
Apples to Apples is very simple and very fun. Alcohol is recommended, but not required. It's best with 6 or more people. It can be played with 4 or 5, but it gets a little boring. http://en.wikipedia.org/wiki/Apples_to_Apples#Rules