Floris Suites is very nice. I've never gone into the Avila but it sounds like a nice place. But if you are going to Curacao for a dive trip, as opposed to just wanting to do a few dives on vacation, I wouldn't choose either. And if you don't like cattleboats I'd avoid Ocean Frontiers. Hooks Hut should be better but I don't know much about them, and as mentioned it's a small trek to Hooks from Floris Suites. Floris Suites is a place I'd stay if I were in Curacao on business. (Actually, I think everyone I saw out on their patio area had a laptop, and I'm pretty sure they weren't working on UW photos!)
Sunset Waters and Habitat are more dive dedicated resorts and their ops have good reputations. There might be a couple drawbacks to these places for you. One is that they are far from fancy, if you are looking at places like Floris suites you probably wouldn't be happy with the accomodations at either. Also, if you really want to be near town, they're not. Personally, I would suggest getting away from town, visit for dinner and sightseeing but stay elsewhere. But that's me.
Kura Hulanda Lodge is very nice, but far away from town. It has Ocean Encounters West next door. It's not quite as convenient as Habitat or Sunset Waters, but pretty good and certainly more convenient then what you're looking at now for diving. Ocean Encounters West should have much fewer people on the boats except for 1-2 days a week they run a bus from the East End then it's cattle city. Sometimes in fact they won't have enough divers to run their boat, but the hotel told me when I was there that if you booked a dive package with boat dives through them they would guarantee the boat ran, I'd re-verify that with the hotel though. You could consider a package that splits time between Kura Hulanda Lodge on the west end and Hotel Kura Hulanda downtown, also very nice and quite unique.
The Marriott is pretty nice too, not too far from town (right across from Floris Suites) and their dive op has a pretty decent rep.
There may be some good option at further east end of the island but I'm not familiar with any of the places down there.
If your ears really prefer to drop with a 40 drop straight down, on many sites you could safely swim out from shore on the surface and drop down where the water is deeper. That seems a bit unusual though, usually people who's ears are touchy prefer a gradual descent.