A quiet PC comes down to three things: case airflow, fan quality, and how hard your components have to work to stay cool.
Start with a case that has good airflow rather than the most RGB. Pair it with larger, slower-spinning fans rather than small fast ones - bigger fans move the same air at a lower pitch.
Finally, a well-sized cooler for your CPU means your fans rarely need to spin up in the first place.