https://en.wikipedia.org/wiki/Category:Songs_about_prostitutes although these aren't necessarily about affection.

I would say this is one of the interpretations of Billy Idol's Rebel Yell. He said in a 2018 interview that it's a song about love, and he has said more than once that the name came from bourbon he was drinking with the Rolling Stones, but I haven't ever read that it was definitely about a prostitute. So that's just an opinion.