Be aware that it's fairly common for many areas to have codes that prohibit certain construction type homes, specifically mobile, or, "manufactured" homes (as that industry terms them nowadays), and the like, regardless how elaborate and expensive.
Also, as a rule, homeowner's insurance for 'manufactured' homes is more expensive than traditional stick built homes.
Other than initial cost, the only advantage of 'manufactured' versus on-site stick built homes is time from closing to moving in
In general, appreciation, or lack of, typically runs commensurate with that of other properties in and around a given area, also regardless how elaborate and expensive.
