I found this thread on the "bug spray weapon" interesting to read. My take is: although I too have heard of people (the infamous 'they') recommending hornet/wasp spray as a defensive weapon, I would not consider it as a conscious choice. If I were being assaulted and the only thing within my reach that I could repurpose as a weapon was bug spray, I guess I would use it. However, I find that scenario extremely far-fetched.
In the scenario where someone could not have a firearm by the bedside (dorm room?), I like Clint Smith's idea of a fire extinguisher "spray them with the foam, then hit them with the can".
12 peers may question why you had hornet/wasp spray "at the ready", but everyone has a fire extinguisher standing by for fires.