Any home I have been in you can definitely hear the rain falling. But it is one of those noises I think you can find relaxing like a fire crackling. The thing I disliked about the metal roof was the major decrease in cell phone signal.
I have a perfect solution for all those issues. Bonus: it's been done for centuries in Europe, tried and tested, it's called "clay shingles". You can observe them... everywhere you go in Europe.
https://eagleroofing.com/lifespan-tile-roof/
Bonus: clay shingles are the longest lasting material you can cover a roof with, and you can repair it by sections. It also looks way better than the crap we use to cover roofs in the USA.
Not perfect: one anecdote from maire above to disprove: "My childhood home burned in the Oakland hills fire - and it had a tile roof -- so roofing material is not enough. Having a defensible space also seems key."
But did that home burn from embers landing on the tiled roof, or from being consumed by the actual fire?
My guesses: Either more expensive or not earthquake-resistant.
Also, if your house is on fire and firefighters need in thru the roof, steel makes it harder for them to get in.