I'm not an expert when it comes to insecticides. In Denver we had little insect pressure in the patch. However, it only takes one squash bug for your pumpkin plant to get yellow vine disease, so spraying appropriately can be important. I would prefer something that is friendly to bees, but haven't found anything that will work for me yet, but if you have any advice, let me know.
Once every two weeks I'll be spraying bifenthrin and on opposite weeks I'll use Orgaocide. This will help make sure I have full coverage.