Motörhead (who has a deep voiced male lead vocalist) has a song called "I'll Be Your Sister".
There's also The Bagel Song, which is basically a dude saying Bagel over and over, edited a bunch of times for different pitches, etc.
Going off Kiwi's Jimmy Buffet post, I always appreciated "Cheeseburger in Paradise" and "Pencil Thin Mustache".
And who could forget Paradise by the Dashboard Light?