For years, homes that were tied to celebrities would sell like hotcakes—but that A-list allure has lost its shine recently.