We live in a water supply area with water one order of magnitude harder than anywhere else in our county.

I'm putting an RO unit in our kitchen to serve drinking and dishwasher needs. Our dishwasher needs descaling after a couple of months of normal use. Other uses (shower, toilets) aren't impacted by our super-hard water, so no RO for the whole house, mainly because of the water waste you note.