The only one that is coming to my mind right now is "Maceo"(Jane's Addiction)...

my cat's name is maceo

My cat's name is Maceo
He's a little man in a cat's body
Well he yawns just like I do
He's convinced that I won't eat him

I think he thinks that I'm his dad
Because I saved him from the pound
Well we went down, down to the pound
And that's where we saw Maceo

La la la la la...

Cat catcher said to me, "Go ahead and pick one out"
And Maceo said "Let me out!"
He sleeps right where I do
And we wrestle in the morning!

La la la la la...

He come to you if you don't bother him
He just likes to do his own thing (do his own thing)
My cat's name is Maceo
He's a little man in a cat's body

Here we go
La la la la la...

__________________
Morning pours the ocean deep
Into the hollow of my sleep
But the ocean can't be mine
Your perfection can't be mine

The Lovecats by The Cure?
Even though it is not exactly about cats.

"Smelly Cat" by Phoebe on Friends.

Agreed

shonen knife - "catnip dream" or "giant kitty"
the sugarcubes - "cat"

__________________
Raise the dead on your turntable.