Clearly Zappa was the man:
The Best Band You Never Heard In Your Life
Shut Up And Play Your Guitar
We’re Only In It For The Money (came out after Absolutely Free)
Does Humor Belong In Music?
You Can’t Do That On Stage Anymore
Jazz From Hell
Favorite is the band Lawsuit with Emergency Third Rail Power Trip. (A Bay Area Rapid Transit in-joke).
Runner-up is I Shaved My Legs for This? by some female artist whose name I’ve forgotten.
But I have to give honorable mention to this classic.
Pretty much anything by NOFX…
Heavy Petting Zoo
White Trash, Two Heebs, and a Bean (the band is made up of Two Jews, one Mexican, and one white guy.)
S&M Airlines
So Long and Thanks for all the Shoes
and of course, the others that gyt_fx mentioned.
KISS–Rock 'N Roll Over. I had listened to it for years before I figured out it meant “Fuck and fall asleep”.
Babylon and on – Squeeze
That would be great if that was an album by …and you will know us by the trail of dead, and they did a cover of Several Species of Small Furry Animals Gathered Together in a Cave and Grooving with a Pict on it 
REM’s Eponymous is one of those “someone had to do it” album titles. Like calling your cover band “The Original Artists” or “No Cover” or “Free Beer”.
I still don’t get what’s clever about Voulez Vous
‘Now That’s What I Call Quite Good’ - The Housemartins
The Shit Hits The Fans - The Replacements
My disappointment upon learning that there was no title song was palpable. I dealt with it by penning the following:
Ahem.
A White Sport Coat and a Pink Crustacean
I’m all messed up for the dance
A White Sport Coat and a Pink Crustacean
And vicchysoisse on my pants
I took her out to Plume de Nom
(That fancy French joint) before the prom
She threw her crab cocktail at me
Because I tried to touch her knee
A White Sport Coat and a Pink Crustacean
And escargots up my nose.
Deana Carter’s album is properly called Did I Shave My Legs For This?
My nomination: Pat Metheny and Lyle Mays collaborated on As Falls Wichita, So Falls Wichita Falls.
Me too!
Okay, my contribution to the thread:
The Talking Heads minus David Byrne: No Talking Just Head
Caravan again : If I Could Do It All Over Again, I’d Do It All Over You
And again: He Who First Smelt It, Dealt It
Keith Moon - Two Sides Of the Moon
… and the winner and world champeen is:
Gregg Allman and Cher: Allman and Woman
If you meant to say Alien Ant Farm (not RHCP) you’d be correct.
I don’t own the album, but I’ve always liked the title:
Diary of a Mod Housewife by Amy Rigby
After David Bowie released his album; Low,
Someone over @ Stiff Records came up with the idea the Nick Lowe release an EP entitled Bowi.
I’ll nominate:
Alice Cooper: Zipper Catches Skin
Pussy Galore: Dial M for Motherfucker
Shiela E: Sex Cymbal
Nugent: Intensities in 10 Cities (Live)
Reagan Youth: A Collection of Pop Classics
A Thousand Points of Night: Read My Lips (EP)
Big Black: Songs About Fucking
Dead Kennedys: Too Drunks To Fuck (EP)
Avant Gardeners: Dig It
Captain Beefheart: Lick My Decals Off Baby
Gurf Morlix - The Toad of Titicaca.
You know, the one with his smash hit ‘Dan Blocker’.
I am the Fun Blame Monster
Pretty good considering it’s an anagram of “the first Menomena album.”
The Chili Peppers released a “best of” called “What Hits?”
This was before “BloodSugarSexMagick”
I think NOFX had a live album called “I Heard They Suck Live.”
Was it the Butthole Surfers that released “Electric Larryland?”