I’m always weirded out by the fact Americans only consider pumpkin good as a dessert thing or soup at best. In Australia it’s very common to have it roasted alongside potatoes for dinner, and I’ve seen pumpkin stir fry and curry in other Asian cultures too.
Though TBF, American pumpkins are specifically bred to be either quite sweet or decorative. I don’t think you can even use American/sugar pumpkin for savoury dishes.
I recommend either Kabocha or butternut pumpkin/squash. Blue or Kent pumpkins are also really good.
You can also steam or roast pumpkin before freezing it, but that takes away the texture aspect sadly.