Won’t an aluminum or steel roof be noisy in the rain?

Not necessarily. Aluminum shingles should be installed over a solid deck, and the insulation in the attic as well as any insulation between the decking and the shingles will help deaden the sound.