For the full sun area, herbs are usually winners with pollinators.....sages, hyssop, fennel, dill, lavender, thyme and others. However, I'm not sure about the cold hardiness of any of those relative to your climate. But in my garden when several of those are in bloom, it's downright dangerous to walk on the path through the middle of those plants.
If any grow in your area, Sedums are very popular with buzzing pollinators.
In the fall, bees seem to lose their mind over Asters, and you should definitely be able to find some cold tolerant varieties for your area. Most Asters can get pretty tall, but I shear mine back 40-50% around the 4th of July, just to keep their height manageable---and so I can see the flowers.