Music can really enhance the experience, but it can also ruin it. If a dev decides to add royalty-free music to their game, the least they could do is browse for 5-10 mins and try to find a song that isn't as widely used. According to Wikipedia, Kevin MacLeod has composed over 2000 songs. I believe even he said that he can't remember all the stuff he composed, and yet people still seem to use the same 5 super popular songs from him.
Hell, you could probably just search generic terms on google like "sad royalty-free music", "romance royalty free music" and other stuff like that and find something that sounds nice that hasn't been heard a million times already.
Also, this is just my preference but some sad or dramatic scenes are much better without music. There were a few scenes in some games that made me laugh my ass off because of the music alone.
If you want a character to come across as serious and intimidating in a scene, it's probably best to just cut the music. You know shit gets serious when the cheery royalty-free music suddenly stops.