While there are probably tons much more recent, here are some (old and non metal songs) that come to mind: Prince in The Beautiful Ones, Steven Tyler in Dream On, Roger Daltry, in Won’t Get Fooled Again.