Not only have I tasted pumpkin pie - I have cooked pumpkin pie from scratch (and that means no canned pumpkin pulp to start with). It is a very important part of our Thanksgiving lunch each year (my husband is American).. I would say, if you haven't ever tried pumpkin pie, don't just screw up your nose automatically until you give it a go. You may be very pleasantly surprised !
You can buy them in Costco. (or you used to be able to - I haven't been for a couple of years). I find it a bit sweet and tacky and bland all at the same time. Somehow, mashing pumpkin and adding brown sugar and spices doesn't quite do it for me. I'll have it plain old roasted any day of the week. YUM.
I had a pumpkin to use and came across a pumpkin pie recipe when I first left home. I thought it was a savoury dish and wondered how it was going to turn out savoury with the ingredients I was using. I really was naive! Anyhow it turned out sweet and tasty. I have made it several times over the years but not for a long time.
If a recipe calls for tin pumpkin I just roast pumpkin and mash it without anything with it. I am not strict about following recipes and usually see them as a rough guide.
My mother used to make pumpkin pie, as a sweet pie, but the American pumpkin pie recipes I have read seem to be sickly sweet. My mother used to use cooked pumpkin and addition was either citric acid or tartaric acid or both. Don't know if it had sugar in it. So it had a sort of tart or sweet/sour taste. Anyway she rarely got the filling into the pie crust because we would eat it before it ever got into the crust.
Sort of like the tartness of lemon tart
Sometimes I see recipes calling for canned pumpkin but we don't seem to have it in Australia. If we did I would make pumpkin pie for sure, at least to try it!
Turning fresh pumpkin into pie is an option of course but I don't feel inspired enough for that.