In medium bowl, stir the water, oil and egg until fully mixed. Add brownie mix and stir until well blended. Spread in prepared pan. Cut corner of caramel pouch and squeeze evenly in zigzag pattern over brownie mixture. With tip of knife, swirl caramel into brownie mixture.
In medium bowl, beat cream cheese until smooth. Add pumpkin puree, eggs, sour cream, sugar, vanilla and spices. Beat until well blended. Pour pumpkin cream cheese mixture over brownie mixture along center of baking dish and spread lightly with back of spoon to edges of pan.
In a medium bowl, combine Snickerdoodle mix and cinnamon sugar. Add softened butter and mix until crumbly. Sprinkle evenly over pumpkin cream cheese mixture. Bake 55 minutes. Cool completely. Refrigerate 4 hours before serving. Cut into bars.