I have stainless steel frets installed on my six string bass that I had put together back around 2007. While they have performed as advertised, in retrospect I sort of wish I hadn't. Allow me to explain with the following pros and cons...
Pros of SSFs: They seem to place more emphasis on the tone of the string at the 'speaking' point. IMO this adds a little more high end shimmer, clarity, articulation, and attack to the sound. Because they make such positive contact with the string I think this also helps increase the sustain and bloom of the note. This is a plus when playing with a pick or playing chordal passages. I've found this to be true with both nickel and stainless steel roundwounds, as well as flatwounds. And as stated in other posts, SSFs are very durable. After years numerous gigs, rehearsals, and practices, to date my frets have virtually no wear on them. Another plus is the SSFs have a very smooth feel, very helpful when doing string bends and slides.
Biggest cons of SSFs: Aside being a bit more expensive to install and dress, they do wear out strings faster than standard frets. This is especially true if you do a lot of slap/popping, double-thumbing, tapping, guitar picking, or if you just play with a really aggressive fingerstyle technique. Again, this isn't news considering SSFs are much harder than standard fretwire. In my case on bass guitars with normal frets a set of strings typically lasts me(with regular use) about 4-5 months before sounding really dull and worn; its about 2-3 months on the bass with SSFs with similar usage.
Obviously the negatives aren't a big deal if you're like Anthony Jackson and change strings after almost every gig or practice. But I'm the type of player who doesn't care for changing strings often. Its not laziness mind you, I've just come to realize that I like the sound of strings on standard frets as they start to break in and wear over time. It sounds and feels more natural to my ear. I guess what I'm really saying that if you like a high fidelity sound, you're willing to shell out a few extras bucks for wear-resistant frets, and don't mind shorter periods between string changes, SSFs might be a godsend for you.