Hmmmm, if 1970s onwards qualify as "modern" songs, that would include too many for me to list!

However, a very *personally memorable* song for me would be Tarja Turunen of the symphonic metal band "Nightwish" singing "Kuolema Tekee Taiteilijan" at the band's "End Of An Era" gig in Helsinki, n 2005:

Tarja: Kuolema Tekee Taiteilijan

I was at that gig. Everyone knew she was leaving the band after this tour, and they've never been the same since.