The post-pandemic frenzy that sparked bidding wars for homes has mostly faded. But cash is still king in some housing markets.