The best type of pumpkin for soup is often the sugar or pie pumpkin, known for its sweet and smooth flesh.