I read a story many years ago about someone, possibly in the FIRE community, who bought a fixer-upper mobile home for super cheap and patched it up. Because it cost so little and I believe they did the work themselves, they got an excellent deal. They lived in it for years on the cheap, while saving up to buy a house outright, then actually sold the mobile home for a small profit because it was worth so little to begin with. I really wish I knew where I read that....
It's my understanding that mobile homes come with all of the responsibilities of homeownership but few of the benefits. It's also my understanding that the lot fee for a mobile home acts kind of like the HOA fee for a condo, and so is subject to increases, but these increases aren't typically as much as rent increases, so there is potentially some strategic value there. If you needed the space and could find a really good deal, it could work out very favorably. I've wondered about this myself. But as housing and rent goes up in price, so too does the cost of mobile homes, since so many people are then looking for these "cheaper" alternatives. Basically, you need to be savvy, not have plans to move it (and some rot into their lot), and, as mentioned, find a good deal.
As for the stigma, well, my pet theory is that it was created by the "NIMBYs" of the 1950s who saw mobile homes as a threat to the value of their traditional properties, and so a great deal of effort went into smearing the public image of mobile homes. But that's just my theory based on extremely limited research. I honestly suspect this stigma is why mobile homes generally depreciate in value. I've wanted to research these more, but most books on the subject are about investing in mobile home parks, and they strike me as kind of sketchy.