When things start going sideways—rusty water, cold showers, rumbling tanks—the big question becomes: is it time to repair, replace, or upgrade?