When I redo a room it gets the colours we like. I don't care about the next owner of the house beyond keeping the house well maintained and gradually improving things like insulation and wiring. Don't like a colour? Change it after the sale.
As it is, the housing market in the Netherlands is completely overheated (seller's market due to a housing shortage), so I could paint every room hot pink and it won't affect the price one bit, but even when that settles down I won't choose boring colours just to push up the price a few thousand Euro.
My kitchen: red walls matched with off white cabinets and shelving; living room: bespoke teal wall filling book case matched with patterned wallpaper (in grays) and an oxblood red sofa and seat (a complimentary colour to the teal); and so on.
I have to live in it and maximizing the joy I get from my house is important to me.