Absolutely! When we were at my great-aunt's funeral the other day, well, first off, it was almost like a DJ kind of thing, because it was a service at the funeral home, but the one that did it for me was Amazing Grace. That song has never made me cry before, it was probably just that powerful of a rendition I guess. I'm not sure who's version they played.
I absolutely agree that music has a way of definitely affecting your mood. (This is why soundtracks are so important in movies!)
Whenever I'm feeling particularly stressed or overwhelmed I like to listen to relaxing music to calm down and clear my head. When I'm feeling nervous or apprehensive I like to sing along to songs that I know well and it immediately makes me feel better.