Behemoth - Conquer All. Good motivation for almost every situation. I say 'almost' because if you work on a bomb squad it's probably not the best choice, since you'll just set the fucker off on purpose.
Running is usually Soilwork, Sprints would be some brutal death, working out can be pretty much anything. Waking up would be something more towards rock.
Edit: Lamb of God - Wrath for pre-action pump/ punching bag work.
Favorite metal songs full volume are great energizers but if by motivation you mean upbeat, then it's typically some combo of Pink Floyd, The Beatles, Camel, Led Zeppelin, and Red Hot Chili Peppers
I would like to work out in silence or at least with my hifi playing instead of my earphones regularly falling out of my ears or having to stop to change tracks/volume but I have to go to the gym and they blast shite like Lady Gaga and Pissycat dolls so I need to cover up their demotivating music.