RMS failure is more likely to happen to a '97-98 Boxster, all the other 986's have about the same chance, but once you get past 25-30k miles your chances of it happening decrease drastically. It was a metal and seal issue, and I believe they updated the seal around '00.
With a 987 it isn't likely but has happened.