My all time favorite was in Chrono Trigger where losing to Lavos was followed by his own ending where he ends the world.

As for Final Fantasy ones I would like to see, I feel FFVI would be cooler if screwing up the Opera sequence netted you a special ending considering it's a non-standard game over. I feel that wrecking the Carship in FFXV should have rewarded a unique ending as well.