I feel that the Cathedral Gargoyles and the Capra Demon are genuinely two of the best (or at least funniest) boss fights in any video game.
The sheer absurdity of getting down to half health on this overwhelming boss and then having a second boss enter the arena is hilarious. And the incredible tightness of the Capra Demon arena is always worth a laugh to me. What takes these beyond gimmicks is that despite how overwhelming both fights seem at first, with a little practice you can do either without much trouble. Real game design.