Thanks for sharing Johnny.
Here's my experience maybe it could help others. I have my plants in two plots with drastically different soil type, clay-ish vs sandy. Keep in mind these were my observations over the years. Mileage may vary depending on your own experience and area. I'm in coastal California. These pictures were taken in 2022.
Ataulfo: I've had some of the longest experience with this rootstock. The easiest to find seeds of. They are the long orange skin mangos you find at stores. Usually very sweet fiberless fruits but one dimensional. Started from grocery store seeds i have 5 large trees between maybe 12 and 18 years old, give or take. I experimented with many grocery store bought seeds then. Back then we use to get a lot of wet cold california winters. Ataulfo seedlings made it, but my Kents never did. This is mostly probably due to clay soils with poor drainage. From what I seen they are slower to get started than Kent seedlings but may tolerate wet clay cold soils better. Not as vigorous a grower as a Laverne Manila but grows fast and steady once establish.
Manila: specifically referring to the Laverne Manila(not a true Manila) available at HD and Lowe's. I grow these currently in sandy soil. But seen it do well in both sandy and clay soil. Hands down considered the most suited and available rootstock for California. This is the one that you don't fail with, many family and friends have these in their yard. It usually very consistently produces small-ish sweet ripe fruits probably due to fungal pressures but can produce larger fibrous fruits when blooms are clean. Can also be consumed green sour crunchy. In 2019, I planted 8 rootstock from HD with the intention of a multigraft. Out of 8, had one very vigorous grower and one slight runt. In 2022, many of these multigraft experiments eventually took place.
Kent: obtain about 6 grafted plants in 2022 of popular varieties. Planted in sandy soil. The varieties known to be vigorous are growing vigorously. It went through it's first first winter this year. My Kesar and CAC known to be vigorous growers has more than tripled in size that 2022 year. You can find seeds from most store bought Costco mangos. Many of my Kents rootstock trees died this winter in 2023 so for the most part I'm not sold on them but it was a strange winter. If it did well I do think i would see more mature kent seedling trees of this but mostly it's Manila and Ataulfo that I would find locally. My Cac and Kesar is still alive, the rest died.
Turpentine: Known to do notoriously bad in California but I believe it may specifically be the Zill strain that is the issue. My personnel experience, 2 dead plants, 2 barely tall 20+ year old dwarf trees. It did not matter if it was in clay or sandy soil. It was probably selected to be less vigorous to slow down their vegetative growth, and to be more precocious. Most Thai varieties seem to really struggle for example.

Ataulfo Rootstock. Clay soil. Kirkland water bottle for size. Unfortunate, I don't have the exact dates. Between 15 and 18 years old. All these pictures were taken in 2022.

Ataulfo rootstock between 12 - 15 years. Clay soil. Smooth bark is due to protection from the most intense time of day in the sun. This tree is next to the side of the house.

Ataulfo rootstock between 12 - 15 years. Clay soil.

Manilla rootstock. Sandy soil. Planted in 2019. Picture taken in 2022.

Manilla rootstock. Sandy soil. Planted in 2019. Picture taken in 2022.

Manilla rootstock. Sandy soil. Planted in 2019. My least vigorous ManilA. Picture taken in 2022.

Kent rootstock. Sandy soil. Kesar. Known to be a vigorous tree.

Kesar on Kent rootstock. Picture taken in April 2022.

Kesar on Kent rootstock. Picture taken in August 2022.

Terpentine rootstock. Clay soil. My oldest tree at over 20+ years old. Barely 6 ft tall and struggle most of it's life.

A better picture of the overall tree. Terpentine on the left. Originally NDM#4 but I began a topwork project last couple years. The tree on the right was planted many years later, Ataulfo because I felt like the terp was going to die. The terp has been looking better the last 7 years or so as I think there may be some root grafting occurring between the 2 trees.

Terpentine rootstock. Sandy soil. This tree is 20+ years old. It may be the saddest tree ever. Blooms but never produce a single fruit in all that.time. Lost the name, a Thai green sweet crunchy variety.

Another picture of the tree. It needs a lot of staking. Sometimes it wants to crawl. About 4.5 ft tall.