Haven't had to rescue anybody else. Have run into 'issues' before diving, something I suspect the 100 dive minimum for the SDI Solo Diver course, and training in it, are intended to give someone a chance to experience. I generally solo in benign conditions, mainly shore diving.
Everyone has to make their own judgment call on risk assessment and tolerance (often without considering hard numbers; many people fear shark attack but not their bathrooms, though the latter is way more likely to kill you). A strong anti-solo bias is often indoctrinated into new dive students and new divers early on with the intention of keeping them out of trouble/risky behaviors, but indoctrination can go too far. A seasoned solo diver diving benign conditions may be lower risk than some newer divers in buddy pairs. Yes, there's potential for problems where a buddy could make the difference. Then again, if you only dove with trained rescue-certified divers, or with a buddy with EMT or paramedic training, your risk would be even lower.
And no matter what you do, there's always risk. Solo diving is a bit like overhead diving and deco. diving; new divers and people without training and experience to deal with the issues would be well-advised not to do it, but those who get those things can reasonably do so. To use your terminology, while I'm scared of cave diving and have no intention to doing any, it's not that I 'don't agree' with cave diving, it's just not for me.
Solo training and certification does not commit a person to only diving solo going forward. It sometimes opens up the opportunity, which may come in handy for a variety of reasons.
In the Bonaire situation, you may find some kind of buddy sign up board as an option. You then depend on connecting with a stranger, personal chemistry between you may or may not be good, there's a decent chance one of you doesn't want to do as many dives as the other, maybe one likes to start out early and the other prefers to sleep in, and divers vary widely in their views of the buddy system - how close to stay together, how tightly integrated to be, etc...
Solo you can dive when/where/how/how-many-times you want. No navigating interpersonal issues, compromising your desires with someone else's, etc...