I love this resort, we go back year in-year out...there's a few of us on here who do the same.
Haven't stayed at the Bonaire as we tend to book direct with apartment owners but have never heard any bad reports about them. As for the weather you shouldn't have any problems....we stayed 6-20 August this year, had a couple of days of cloud but it was nice as the heat can be very intense (not as intense as Cyprus tho'), we had morning where it rained for about half an hour and then the sun was cracking the flags.
Can recommend Eileen & Pedro's - Supermercado Ca'n Pedro just past the Alicia but before the Bonamar....lovely couple and Pedro makes a mean sarnie in a choice of bun for €1.60...they are also good for your cheap booze.
There's a Bip supermarket on the back road in Cala Bona which the locals use and there's a big Lidl at the bottom end of Cala Millor...it's a good walk but worth it...take a trolley suitcase for your buys or get a taxi back.
Food wise...as a family of 5 we could eat out for about €40 and that's including a soft drink each...can heartily recommend the Argos Bar on the front which was very good value for money and their cooked breakfast was delish. If you fancy a short walk...try CHEERS in Cala Millor where you will always be guaranteed great food at very reasonable prices...it's our favourite haunt and has been for 11 years.
As the Bonaire is part of the Protur group make sure you have at least 1 day at La Reserva in Sa Coma....this year they did a discounted rate for Mon-Fri and if you were Protur guests you got it cheaper still.
Basically opens at 10.30am and closes at 5.30pm...inside it's a mini waterpark of sorts suitable for the whole family, dedicated child area but even the main pool wasn't deep. You get your breakfast (continental), lunch (cooked) and tea (cakes etc) plus ALL your drinks (soft & alcoholic) and as many ice lollies/ice creams as you want during your stay.
Kids absolutely loved it, we all did and had a fab time this year, planning on going 3 or 4 times during our stay next year.