I generally have a few "forever games" that I sink thousands of hours into. Right now that's Stellaris but in might try to get back into Crusader Kings with the new patch and of course when Civ 7 comes out I'll be all over that.
I generally prefer my other games to be fairly short, especially for story heavy games. I've left hundreds of Civ games unfinished, and it doesn't really matter, but I do actually want to finish games with a strong narrative, and really long ones can be hard. I never finished either of the Divinity original sin games, for instance, despite enjoying then quite a lot. Same with Witcher 3, though in that case it has more to do with rapidly becoming fatigued with the open world and also starting grad school about 3/4 if the way through and not having much time to play. I'm general though, I'd say about 20-30 hours is ideal for a game that I can't just replay forever.
Yes -- America (original by Simon and Garfunkel)
Anthony Vincent -- Chop Suey in the style of Ghost (original by System of a Down)
Dr Pez & Marc Papeghin -- The soundtrack of Ocarina of Time, but its a prog rock concept album (not sure it technically counts as a cover)
Brass Against -- The Pot (Original by Tool)
The Jimi Hendrix Experience -- All Along the Watchtower (Original by Bob Dylan)
Also, not sure how widely known this is, but Arethra Franklin's Respect is itself a cover (and certainly one of the best covers of all time, up there with All Along the Watchtower and Johnny Cash's rendition of Hurt)