I was getting huge traffic from MSN for the search terms "naked women" and "foot fetish" until I banned MSNbot and psbot from spidering my site. the naked women post was really about beer, and the foot fetish post was really about Foot and Mouth disease in sheep.
I still get huge traffic to my site from google for the search term "jennifer aniston's butt" leading to a post I wrote last year. It makes me laugh when I wonder what they think when they thought they were going to see the good stuff only to see a bearded fat guy.
is the post.
Of course I've help the Aniston post along by optimising the hell out of the page for that search term. Just for the chuckles of course.