My mom's house had carpenter bees really bad. I remember the year they showed up and I was about 12. I showed my dad and thought he should do something about them. He didn't.
After about five years there were holes drilled EVERYWHERE under the edge of their roof the whole way around their house. I was the only unfortunate one to actually get stung by one. I stepped on it and it seriously drilled a hole in the bottom of my toe. The scream I let out scared my mom half to death because I grew up with boys and got shot with a bow and arrow and pulled it out myself, and I went two weeks with my arm broken in three places until I finally got a cast so I had a high tolerance for pain. Let me tell you...that hurt like CRAZY! My mom had to get the stinger out because it was drilled in and didn't want to come out. You could see the hole it left in my toe without even trying.
WD40 has a straw attached to it now for a reason...lol! Hubby shoots that in the hole if he sees one starting and the bee immediately falls out of the hole dead. It smells better than bee spray too.