Would have been a lot easier with a drill press, but it was still doable, just tedious drilling.
I still have yet to see one on a flower. Only have seen them just inside the holes in the evening or after dark. Mostly bumblebees and carpenters on my blueberries.
I think you are an hour or two north of me so I’d bet you can still get some. Monday this week was my first sighting and I think they are active for a month or so.