My absolute favorite "raunchy" guitar tone can be heard in Stone Temple Pilots song, Sex Type Thing. Particularly the tone during the chorus. Its full of mids and presence, but it doesn't go so far as to be 'farty'. Its just perfect.
The way its pushed up a little bit in the mastering during the chorus gives it a little bit of kick.