I don’t know but I would guess virtually everyone who buys a house hopes its a smart financial move. Therefore to some extent I would say everyone is hoping to feel a bit clever on their transaction, at least to some degree, though they may have other motives as well.
No RE agent tells a client, well this would be a really Shitty financial move but it sure is a nice house.