Songs in a story

What is your opinion of a character singing? For example, (all you Hunger Games fans will know what I’m talking about) when Katniss sings to Rue as she dies, the author included the words to the song in the book.

But for those authors out there (okay fine, I’m talking about myself) who cannot come up with an original song, how do you go about describing how this particular character sings? Other than the obvious details like saying the singer has a deep voice or a soft voice, how do you really capture such a moment, such as when the hero of the novel sings to the heroine, effectively stealing her heart?

I am struggling to write such a scene. I have the perfect music video for inspiration, but I just am unsure if I should attempt to write a song, or if the song itself will only take away from the character himself.

Okay, so here’s my inspiration:

So what do you think? Song or no song?