I think there are different kinds of "successful" here.
A) Does the RPG, as an RPG, work well rules-wise, and achieve its own goals design, artistry and tone-wise?
I think, historically, there have been a lot of RPGs that don't. Including ones that did fairly financially successful, at least...