I like Sing the Sorrow a lot too. Perhaps less now than then, but still. I don't recall whether I knew it was a Butch Vig production or not. But I do remeraber paying attention to his name in the 90s, he was one of 3 or 4 producers I paid attention to. For some reason the only one that comes to mind is L7's Bricks are Heavy, but it looks like he also did Nevermind, the 2 best Pumpkins albums, and my favorite Helmet. Go Butch! :beer: He's also done Garbage though which I don't care for...but that's the band's fault, not his.
Anyhow yeah, I think you're right that Dirty would be a good starting point for the SY noob. I should have picked it up that day.