Preheat the oven. Preheat the oven to 425°F. Line a rimmed baking sheet with parchment paper, if desired, to simplify cleanup.
Season the butternut squash. Arrange the cubed butternut squash on the prepared baking sheet. Add the honey, melted butter, salt, and cinnamon. Toss thoroughly until the squash is evenly coated, then spread the cubes into a single, even layer.
Roast the squash. Roast for approximately 25 minutes, or until the squash is tender and lightly caramelized around the edges. Remove from the oven and set aside.
Sauté the onion. When the squash is nearly finished roasting, heat the olive oil in a large soup pot or Dutch oven over medium heat. Add the diced onion and cook for approximately 5 minutes, stirring occasionally, until softened and translucent.
Add the carrots, garlic, and ginger. Stir in the carrots, minced garlic, and ginger. Cook for an additional 1 to 2 minutes, stirring frequently, until fragrant.
Add the roasted squash and liquids. Add the roasted butternut squash to the pot, followed by the vegetable broth, apple juice or apple cider, lemon juice, honey, kosher salt, curry powder, coriander, cinnamon, nutmeg, and turmeric. Stir until well combined.
Simmer the soup. Bring the mixture to a boil, then reduce the heat to medium-low. Simmer for approximately 10 minutes, or until the carrots are completely tender.
Add the pumpkin and dairy ingredients. Stir in the pumpkin puree, softened cream cheese, and brown sugar. Mix until evenly distributed. The cream cheese may remain slightly clumpy at this stage; it will become smooth during blending.
Cool slightly before blending. Remove the soup from the heat and allow it to cool for several minutes. If using a countertop blender, transfer the soup in batches, taking care not to overfill the blender with hot liquid.
Puree until smooth. Blend the soup until completely smooth and creamy. Alternatively, use an immersion blender directly in the pot until the desired consistency is achieved.
Add the heavy cream. Return the blended soup to the pot, if necessary, and stir in the heavy cream until fully incorporated.
Adjust the seasoning. Taste the soup and add salt and freshly ground black pepper as needed. For a less sweet version, omit the brown sugar and the additional honey added to the soup.
Serve. Ladle the Creamy Autumn Squash Soup into bowls and garnish with pepitas, a drizzle of cream, and a light sprinkle of paprika. Serve warm.