Michael is correct, the bees do more for the pumpkins than the pumpkins do for the bees. Like other members of the cucurbit family, (summer squash and ghourds) pumpkins require bees for pollination. Ten weeks after planting, the first flowers suddenly appear between leaves and tendrils. Each flower blooms for
only one day. They start to unfurl just before dawn, and during a four hour period, they open into luxurious velvet bowls. By mid-day, they are on a slow course of folding in on themselves; and by dusk, they are sealed forever.
Every pumpkin plant has two kinds of flowers -- male and female. Both are golden yellow, suggesting the color of the fruit to come. On the surface, males and females look quite similar. However, with a little observation you can begin to tell them apart. The male flowers, which appear first, sit on long thin stems and are more plentiful than females. The females sit closer to the vine and rest like queens on fuzzy round thrones. Bees are the matchmakers, gathering pollen from the center of the males and depositing it inside the female flower while glutting themselves on sweet nectar.
As you may well imagine, with a flower that is only open for one day, you need quite a few plants to do anything for a hive of bees! If you put your hives on a large pumpkin patch with flowers opening daily for a week or more, then you might be able to collect a pumpkin honey!
As for flavor, I love pumpkin pie, and even just the squash itself cooked with butter. So the flavor of the fruit is pleasing to me, and I imagine the honey would be as well. I have never had any however. :D