Only thing I can think of is Aquarela do Brasil, but that's only because of Terry Gilliam...
I'm sure it doesn't truly count, but The Vaselines have a song called The Day I Was A Horse about being a horse for a day. It might actually be about drugs though idk. Not strictly kafka-esque, but it is at least somewhat Kafka-adjacent.
I have no idea what you mean by that, but I really like the song Metamorphosis by Infinity Song.