I always start by preheating the oven to 350°F so it's fully heated by the time my batter is ready. Line your baking pan with parchment paper, leaving a little overhang on the sides for easy lifting later. This small step saves me from any sticking disasters once the cake is done.
In a medium bowl, whisk together the flour, baking powder, baking soda, salt, and pumpkin pie spice. I like to give this a good minute of whisking so the leaveners are evenly distributed. This prevents any weird pockets of baking soda flavor in your finished cake.
In a separate large bowl, whisk the melted butter with both sugars until it looks glossy. Add the eggs, pumpkin puree, sour cream, and vanilla, then whisk until fully smooth. I make sure my butter has cooled slightly here so it doesn't scramble the eggs.
Pour the dry mixture into the wet ingredients and fold gently with a spatula. I stop mixing the moment I don't see streaks of flour anymore, since overmixing is what makes coffee cake turn tough instead of tender. Pour the batter into your prepared pan and smooth the top.
In a small bowl, stir together the flour, brown sugar, and cinnamon for the streusel. Pour in the melted butter and mix with a fork until you get coarse, clumpy crumbs. I like to pinch a few pieces together with my fingers so the topping has some bigger, bakery-style chunks.
Sprinkle the streusel evenly over the batter, then slide the pan into your preheated oven. Bake for 35 to 40 minutes, or until a toothpick inserted in the center comes out clean or with just a few moist crumbs. I start checking around the 30-minute mark since ovens can run hot.
Let the cake cool in the pan for at least 20 minutes before lifting it out with the parchment overhang. If you're adding the glaze, whisk the powdered sugar with a tablespoon of milk until pourable, then drizzle it over the cooled cake. I try to be patient here, because slicing it warm makes the crumb fall apart.