While hardwood floors and new appliances often steal the spotlight, plumbing quietly plays a starring role in how comfortable and functional a home really feels.