In my opinion, canned pumpkin gives you the best overall texture. Homemade pumpkin tends to be stringy and contains more water, so it ends up more jiggly instead of firm and creamy.