Most dramatic breakfast would probably be the one delivered by canoe to your overwater bungalow on Bora Bora... most of the hotels there do it.

But one of the things I most enjoy when on vacation is the ability to sit peacefully, with very few people around, and drink coffee with my wife for a couple of hours while gazing out at the ocean before beginning to actually eat breakfast. This was likely accomplished best when we were at Bora Bora Nui and a the Sheraton Pattaya. Key ingredients are that the breakfast restaurant isn't too crowded, noisy... that it have a wonderful ocean view... and outstanding, strong coffee (with soy milk or at least 2% for mrs. gleff and half and half or heavy cream for me). Details of the buffet itself are almost secondary, but some noodle dish and dim sum are pluses. Interestingly, breakfast was included both times (at the Nui I understand breakfast is no longer included for all guests, and at the Sheraton Pattaya they offer that as a SPG Plat benefit).

Room service breakfast: best omellette I've ever eaten was actually delivered by room service at the W Seattle, a wonderful yet simple avocado and bacon omellette.. avocado perfectly ripe, bacon of high quality, little fat, firm and crisp but not overcooked.