There are so many good options in Bonaire.
We first stayed in 1996 in a fine small guest house one block back from Kaya Grandi which is still there but no longer a guest house, and you would not want to be there now, surrounded by parking lots and traffic even if it was. But it was great at the time. We have had good experiences at Eden Beach, Caribbean Club and a semi-longer term rental at Bonaire Exclusief in a charming house a couple of blocks from the sea that shares a beautiful pool with the other houses in that property.
The strip north of the circle from Den Lamen to Hamlet Oasis, including Sand Dollar, Buddy, Habitat and across the road, Bamboo Bali have a well deserved reputation and have lots of advocates here.
But an area that seems to get little attention are the places on Boulevard Craane, just north of town center. We have rented at Playa Lechi resort and Elegancia del Caribe, but there are other casual spots like Kas Hamaka and Seaside apartments, amongst others in this strip. Fabulous sea views from the properties with the cruising boats from all over the world moored out front. Step across the boulevard for great dives, night and day. Tarpon almost guaranteed and young turtles feeding on scraps from the local fishing boats, striped juvenile angel fish and morays hiding in the mooring blocks, octopus and more. If you want the flexibility of Dive Friends multiple locations, Yellow Sub is right there, but my favourite is the friendly stafff and great service of Gooodive right on DeBrot. Plus, you are 10 minutes walking distance from town centre so you can watch sunset from Karels ( if you want more sociability than the equally good view from your own place), eat at the spectrum of restaurants from the casual like Pasa Bon, Rumba or Bobbejans or the fancy like It Rains Fishes, La Terraza or Mona Lisa, amongst others, without having to count the number of Amstels or glasses of wine you imbibe since you can leave the truck keys at home and have a short stumble back without any fear of a DUI. It checks all the boxes. We like it so much here, we now have our own apartment in this area.
You can book these through VRBO, Homeaway, etc., but there can be selection at better prices through Comfort Rentals, Paradise rentals or Sunbelt, for example. You may have to arrange your truck and tanks separately, but that is fairly easy to do.
Andy