Cucurbita foetidissima is known by many common names: Calabazilla, Wild Gourd, Stink Gourd, Buffalo Gourd, Coyote Gourd, Missouri Gourd, Fetid Wild Pumpkin, just to name a few.

Utah State University describes Cucurbita foetidissima as a wild cucurbit (cucumber family) that grows vigorously from a thick carrot-shaped root that can grow over 5 feet deep and very wide. (Based on the article you provided, the root of this plant can weigh as much as 100 pounds.) It is a trailing perennial with numerous stems reaching over 20 feet long. Its gray-green, rough textured leaves stand about 1 foot off the ground and have a strong, unpleasant odor when they are crushed. The flowers are infrequent. They are rich yellow and may be as much as 4 inches in diameter. These are followed by round, dark green fruits that develop cream-colored blotches and stripes as they mature and become hard. The plant gets the name "stink gourd" from its foul odor.

It is known as an arid-land crop, with its native habitat in open areas on plains and deserts. Arid-land vegetation adapt to gravelly, sandy soil with natural irrigation (rainfall). Recently, a Colorado homeowner in El Paso County found this plant running amok on their property and was having a difficult time eradicating it because new plants were popping up all over on their property.

Here are two additional pieces of information you should review.

https://www.wildflower.org/plants/result.php?id_plant=CUFO

https://www.texasbeyondhistory.net/ethnobot/images/cucurbitabg.html (note the photo of the root – 16” wide)

To answer your question: what do you think about this plant in a suburban setting? This would not be a good choice based on all of the information available.

And close to a house's foundation? Not with a root system such as this one.

If this is something you really wish to pursue, search with the parameters: "Cucurbita foetidissima site:.edu" to get information from educational institutions. There are plant descriptors that should give a homeowner pause when deciding on a plant for their landscape:

wild

vigorous

unpleasant odor...just to name a few.

Here is some information on vines for the home landscape:

https://planttalk.colostate.edu/topics/trees-shrubs-vines/1727-vines-colorado/

https://www.johnson.k-state.edu/docs/lawn-and-garden/in-house-publications/perennials/Perennial%20Vines_REV.pdf

https://aces.nmsu.edu/ces/mastergardeners/manual/docs/chap_4/chap4.k.pdf

And finally, CSU recommends that vegetation be planted no closer than five feet from a home’s foundation, unless the plants have very low water requirements. Xeriscape-type groundcovers and mulches are especially useful near houses because they can help reduce extreme moisture fluctuations.

https://planttalk.colostate.edu/topics/soils-amendments-composting/1617-expansive-soils/