Preheat oven to 350°F (175°C) and grease a 9-inch square baking pan with butter or non-stick spray.
In a medium bowl, combine 1.5 cups flour, 1/2 cup granulated sugar, 1/2 cup brown sugar, and cinnamon. Stir in 1/2 cup melted butter until thick crumbs form; set aside.
In a separate bowl, whisk together 2 cups flour, baking soda, baking powder, salt, and pumpkin pie spice.
Using a stand mixer, cream 1/2 cup softened butter with 3/4 cup granulated sugar and 1/4 cup brown sugar on medium-high speed for 3 minutes.
Add the egg and vanilla extract, beating until fully incorporated.
Mix in the pumpkin puree and sour cream until the mixture is uniform.
Reduce mixer speed to low and gradually add the dry ingredients, mixing only until no flour streaks remain.
Spread the batter evenly into the prepared pan.
Distribute the streusel crumbs evenly over the top of the batter, pressing lightly into the surface.
Bake for 40 to 45 minutes, or until a wooden skewer inserted into the center comes out clean.
Allow the cake to cool in the pan for at least 20 minutes before slicing.