I'm interested that "Heroin" was the song that made you feel like that. I've always felt that "European Son" (YT: http://www.youtube.com/watch?v=igWyYA_r06Y) was the most experimental and noisy song on the album, and I always experience a real visceral thrill when listening to it (especially that part with the roar-ish thing and then the glass shattering). The guitar parts are absurd, the band sometimes plays straight screeching noise, and the song barely holds together. "Heroin" feels contained by comparison.
In a similar vein, considering your appreciation for "the clash of consonance and dissonance," I hope you're getting a chance to see My Bloody Valentine during their short tour in the next few weeks.