I actually agree that Secret of Mana is one of the best covers. I was looking through games trying to find a better one, and there really aren't many.
One that I'd definitely put above it though, is the original Dragon Warrior.
Your mileage may very based on your fondness of dragons, but it is quite possibly the most badass video game art that has ever existed.