New-home sales drop by most since 2022 on poor affordability