I think brake pads can be classified into three categories: soft, medium and hard.
The harder the pad the more they will wear the rotors. Rotors can be carbon steel, stainless or ceramic.
The soft pads are organic, will wear the rotors less, may take more effort, can tend to fade, and will wear out the quickest.
The medium pads are like organic pads but have some metal elements included to make them harder for better braking characteristics but will tend to wear out the rotors quicker. These could also include Kevlar but I think that is just a sales gimmick and probably these type pads are softer also just a shade harder than organic.
The hardest pads are the metallic pads, including sintered and will usually have the best braking characteristics but will wear out the rotors the quickest.
There will be arguments about rotors and pads and compatibility but generally the better braking characteristics will cost you greater rotor wear since there is nothing for free.
The best determining factors are actually the way you ride and where you ride.
Myself, I am a fairly conservative rider so I want organic pads for the longest rotor life. I've already wore out one set of rotors and am on the next set which I am sure will last longer since I am using organic pads.
On the other hand if you ride like an enduro rider, and wear tires out in less than 6k miles, them maybe you would want better braking characteristics at the expense of your rotors.
I am not convinced that keeping with the same manufacturers rotors and pads will yield the best results but you will find many proponents of just that theory. They all want to sell pads and rotors. The manufacturers that is!
The are no pads that will immediately fail and kill you so trying a different pad isn't dangerous and if you don't like the way they work, well just buy a different type.
I think the stainless rotors are softer than the carbon steel rotors so they ought to wear out quicker. Ceramic rotors need special pads made by the same manufacturer as usual.
My first set of front rotors wore out at 71k miles using pads from the dealer. They got to a very thin condition and they sure were shiny. I'm sure with braided cables I could have gotten a lot more mile out of them.

Not really!

***