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.
http://www.spudooli.com/photo-66.html 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.