Part of the reason people like Trump have very fancy residences is because they are exempt under bankruptcy laws. So he can store his wealth as gold plating on his toilet, file for bankruptcy, get out of all the loans he can't pay, then continue on with his lackluster investing. I bet even a tax on the value won't remove that very lucrative use of it.
What a principal residence as an investment does for most middle to upper-middle class Americans is force them to save some money so that they have some amount of wealth when they retire. I don't know if that is important or not, since it's not very liquid and has dire consequences if you lose it.