There's tons of demand in a lot of hot areas (such as bay area and NY) in the "low end" range of $1m (I know right). Just look at redfin in these areas. Anything reasonably nice under $1m is a hot home.
There's too many things working against the high end: higher property taxes, lower tax incentives (SALT reduction), and higher interest rates.