I don't like music in major-key but make an exception for Bad Moon Rising by Creedence Clearwater Revival, who specifically talked about how he made the juxtaposition between upbeat music and lyrics about the apocalypse and doom a deliberate choice and made one of the all-time classic songs.