I lived under a metal roof for the first 21 years of my life. Big Victorian with a standing seam roof that had been installed in the 1920s.
It was maybe a bit louder, but nothing that would drive you nuts. With proper attic insulation, you'll probably never notice.
If I were looking to rent, a metal roof would be no detraction.
If I were looking to buy, it would be a significant positive.
If you're looking at metal roofing, go with a company with a track record of installing, repairing, and maintaining metal roofing.
As the article says, thicker is better because it's more resistant to hail damage.
If you live in a snow area, you'll want ice eagles or snow guards. Don't buy into the theory that a metal roof will shed snow as quickly as it falls. On a standard pitch roof it won't, and when it breaks loose it can take out spouting and do significant damage on the way down.