I would have to say that the album that filled me with the most emotion would have to be Dark Side of the Moon. Every bit of that album makes me feel emotional... Breathe, Time, Us and Them, Brain Damage.
Also, The Wall helped me through some times. And I will admit, Echoes has driven me to tears.