While the pumpkin is native to North America, the concept of a pumpkin pie probably originates from England; the earliest recipes can be found in English cookbooks such as The Gentlewoman’s Companion from 1675. Of course, today we know and love the pumpkin pie as a tradition to eat during Thanksgiving.
What most people don’t realize is that the “pumpkin” used in most pumpkin pie filling doesn’t use the kind of pumpkin we usually think of as a “pumpkin” (the orange, decorative pumpkins used for jack o’ lanterns). Those tend to be too stringy, too watery and not flavorful. In most cases (including Libby’s canned pumpkin) they use what’s called a “Dickinson squash”.
If you’re lucky, you might be able to find sugar pumpkins at a local farmer’s market or farm stand (also known as pie pumpkins or sweet pumpkins) which aren’t stringy and are excellent eating, either as a pie or roasted. If you do, grab one.
The best recipe I've found for pumpkin pie from scratch is this Sugar Pumpkin Pie Recipe from AllRecipes and fresh pumpkins that I got from one of our local farms. Sorry for the slice out of the picture; it smelled so good I tasted it before I remembered to take a picture of it.
I'm not the world's greatest nor most confident cook, but when I brought it to our family Thanksgiving gathering it got rave reviews. People who said they normally couldn't stand store-bought pumpkin pie said that it tasted fresher, lighter, and creamier than store-bought pie.
If you don't want to bake your own pie, there's always Goldbelly, where you can have pumpkin pies shipped from anywhere in the US from the country's most famous restaurants and bakeries. And of course, if push comes to shove, there's always good old Sara Lee.