I think someone who expects to visit Bonaire once in his life and never again, and who will give up diving soon, will approach it differently from someone who goes and says 'Maybe next time I'll...' dive the east coast, try Klein Bonaire, hit some sites in Washington-Slagbaii Park, etc...
Hintermann, you've got far broader dive experience today than I will probably have when I die. So take this with a grain of salt. Here's what I think you will find Bonaire, and its hype, to be.
Bonaire is the 24/7 'all you can eat, self-serve' buffet of scuba diving, offering mainstream sloping wall (coral reef) diving in very good viz., warm water, low-current often aquarium-like conditions outside the hurricane belt with little seasonal variation so whether you go August or December doesn't matter all that much.
Like good food buffets on land, it offers good diving, all you want, at an excellent value price overall. You dive when and where you want for as long as 2 tanks can hold you & your buddy.
That's the magic. That's the hype. That's why I've been there 8 times, a week per trip.
Bonaire is not...
1.) Sharky.
2.) Great for big stuff (aside from tarpon, a few big barracuda, green moray, a few tiger grouper, cubera snapper, the occasional fairly big turtle, rainbow parrotfish, midnight parrotfish).
3.) High variety. Yes, the Cliff & Small Wall offer vertical walls, and the east coast is different, but the mainstream west coast dive sites most hit most of the time tend to very roughly follow a general form. Some better than others.
4.) Super convenient - if you love live-aboard diving where you set your gear up once, staff refill your tank between dives, and you only haul gear walking to & from your bench to the rear to giant stride in or ladder out, then hauling gear around in a truck, walking in geared up, watching your footing in the shallows, etc..., is more work.
I love Bonaire. I recommend it highly to people who will love what it offers. But don't expect the drift diving and varied topography I've heard Cozumel has, the sharks of the Bahamas and Turks & Caicos, the topside lush rainforests of Dominica and Saba, the 'best diving in the Caribbean' I keep hearing is found at Bloody Bay Wall in Little Cayman, the big animal action of the Socorros/Cocos/Galapagos, the biodiversity of Indonesia, those neon-colored nudibranch photos of the Philippines & other places, etc...
If you come to Bonaire with a mindset to appreciate it, I think you'll like it. But don't come as a seasoned gourmet diner seeking a made-to-order specialist delicacy entree'. Come as a mainstream food lover after plenty of good value good eating and stuff yourself.
My 2 cents, anyway.
Richard.