I know someone who just sold a canyon rim home on Mission Cliff (further west, west of Texas). It was a smaller home and fixed perfectly for the homes style – but commanded a larger price to the OP’s potential purchase.
Canyon rim homes do call for a premium. Ones in good shape absolutely call for a premium.
What you don’t mention is how YOU feel about the home. Your husband loves it. Will you be happy in it?
I got grief from my father when I moved to downtown San Diego in the 80’s (pre gentrification). He said he’d never visit. That was an empty threat. Then when I moved to Philly in the early 90’s he swore he’d never visit… Ended up conceding that both moves were right for me and that my choices were not mistakes.
Sometimes family intends well but is looking through the lenses of their own needs, not yours.