I lover screw-down metal roofing for barns, shops, outbuildings, etc. where a little leak every now and then will be of no great consequence. I know that everytime I've been working in my shop or barn from morning until afternoon I can hear the expansion/contraction of the metal as the sun warms it (squeaks/pops/etc.). Everytime this happens, those gaskets get a little looser. It's been built 10 years or more, and it might have just a couple of dripping leaks, nothing to worry about in the shop - but I don't want it in my house, that's for sure.
I've helped my father in law replace all the screws on his roof - he had metal screw-down roofing installed my laying it directly over the old shingles - no purlins, no tear off, no nothing. Most of the screws we removed were rusted/rotted out and we had to remove one small piece of metal and it was rusted underneath.
I think a lot of folks like the metal for the looks, and a lot like it for the cost, because they feel they can skip the tear-off of an old roof. My opinion on roofing is that if the roof is in bad enough shape that it needs to be replaced, it needs to be removed. I hate doing roof tear-off too, but as others have said, the first step in a good roofing system is proper preparation, no matter what type of roof you're installing.
If I were to install a metal roof on a residence, it would be standing seam, but I prefer the looks of asphalt shingles. Additionally, I've only had one small portion of shingles that has ever blown up, and that was during a hurricane-force wind event (and we don't get those often in KY).
Whatever you choose, good luck and take care.