Since you asked. Most of the motherboards I've worked with recently let you set a custom fan curve with the option to turn the fan off completely. You can also adjust which temperature sensor the fan curve is based on. This can be controlled for each fan connected to the motherboard.
One feature that I've really grown to love that I don't remember ever seeing with custom machines is the ability to fully customize the fan-curve, including the ability to completely turn off the fan below certain temperatures.
This makes it as good as a truly silent build for most day to day use, but with effective cooling available for intensive tasks for when I need the extra power.
Maybe these days there are motherboards that allow you to configure the fan curve this way as well? I personally think this kind of configuration gives the best of both worlds.