At the risk of stating the obvious, surely ROPS is only going to protect you against overrunning the runway that the system is expecting you to land on?
That was my initial reaction, but having looked into it, my understanding is it works like an extension of EGPWS, and so provided the runway is in the database ROPS will identify that you're trying to land on it and provide warnings as appropriate.
Now if it could provide a warning that the runway in front is not the one programmed into the FMS [even in the case of a visual approach] that would be the icing on the cake in a situation like this.