There are to many notable homes that can't be purchased and in my option a real lot of the homes are crappy. They aren't in good shape. A lot of the designs aren't good for a home.(again my opinion)
Nobody else can determine what looks good to you, so I'm not even sure what home you're referring to here. I'd bet I like some of the homes you dislike though, since I like most of them lol.
Anyway a lot of times the homes tied to a chapter come back during a random anniversary of their release, so it's possible the ones tied to Blackwood will be on sale soon. Other than that, there's not really a set time when they come back. And once they're gone in can be a couple years before they return.
So... which houses are you referring to? We don't know what you consider best unless you tell us. To give a vague guess probably around an event that takes place in the zone these unnamed houses are in.
They use the Disney Vault style of sales to try to include FOMO. So most houses are on about a year and a half cycle with some being yearly.
Yeah, housing sales definitely capitalize on FOMO. It's a pity, because they are really expensive, abd it's difficult to be able to buy them whenever they might pop up, and the pattern of returns is not standard, for eg., some houses tied to regions where events take place go on sale during events (like Stone Eagle Aerie this week with the Skyrim event) but it's not always the case, and the sales are unpredictable, with some houses taking really long to come back.