There's many songs that have made me feel like crying, but I can only think of one that actually did make me cry, which was Opeth - Requiem.
Actually, come to think of it, back when I was about 15 or 16, The Offspring's 'Have You Ever' made me rather teary.