Homemade apple pie rules the roost, followed closely by homemade pumpkin pie, then homemade pistacio pie.
When you say "homemade" do you mean from a pumpkin or from a can of pumpkin, cause really I consider homemade even if the filling is from a can. I had "real" homemade pumpkin pie once. Some guys I knew, while I was single, actually took a pumpkin, spooned out the insides (minus seeds), cooked it, added the spices, I made the crust, and we put it together in the oven. It tasted the same as the canned stuff, but had a different texture. I felt like it wasn't worth the trouble (unless you're trying to use up a pumpkin so it doesn't go to waste).
My favorite thing to do when making pies is to buy the refrigerated pie crusts (that are rolled up). They're just as good as homemade. You can get two for about 2 bucks and it's so much easier than making it yourself. I know, crust isn't that hard, but I make a mess every time and it's a pain to clean up.