We have old-school corrugated metal on our house, shop, and outbuildings... the ones that were new 35 years ago (on the house, and part of the shop) still look like new; the "recycled" ones (that are coming on 100 years) are starting to have rust issues... I was told they will last another 20 years, but I am thinking it's time...
The noise? In the uninsulated shop (more on that in a sec) it's there, but not bad - I know when its raining, and you get used to it - I kinda like it. And the snow melts down once the shop is heated. In the house, there's 2 layers of wood and insulation, so the noise is almost non-existant...
Insulation-wise, however... non-existant. One of the BIG additions to the new roof for the shop (along with the beams and reinforcement for weight) will be some kind of insulation, as in the winter I run 2 heaters and it can still be chilly; in the summer, I have fans and windows and the big peak door (looks like a barn hayloft door) going, as that roof radiates all that heat into the shop.
Saying all that - having had a metal roof, I wouldn't go back to comp... especially comparing replacing in 30 years, and replacing in 100+. My only thought - living in the sticks where there is little industrial pollution to rot it - if I can swing it costwise I'd go Copper over Steel, to eliminate the rustout issue... at least until my great grandkids have to replace it in 150 years (maybe)! (I've seen 200 year old copper roofs in Europe and Russia that, other than regular maintenance, are still solid, and will likely be that way for another couple hundred years!)...
I may have to sell the grandkids to do that, tho! lol