I've used metallic pads (always noisy) and resin (occasionally noisy), never tried ceramic.
I learned a few years ago that making sure that rotors are clean and "bedding" new brake pads results in quieter and more effective braking. My commuting environment is pretty gritty, so this is very important for much of my riding.
Here's one article that seems to capture the idea pretty well:
https://www.bikeradar.com/advice/wor...sc-brake-pads/