I haven't been on a coaster yet that I won't ride again. Sure, if I only have a day at a park with a lot of great rides, I might skip something, but that doesn't mean I won't ride it.
As for some of the rides previously mentioned:
Mean Streak: Quite slow, quite rough, but I definitely see the potential for a good ride. I'd ride it. It is a coaster.
Mind Eraser (SFO): I didn't think it was horribly rough. It's more disorienting for me than anything else, but I would ride it again.
Steel Phantom: I'd pay good money to ride it again. I've only had an incident on there once (which, granted, is more than should happen). On my first time riding after about a 6 year or so absence from coasters, we flew back up the ravine and nailed the trims. I wasn't expecting this, and my head lurched forward, only to go crashing back onto the headrest. No blood or even a headache, just a little unexpected bump.
This may sound odd to you, but I really want to ride one of the Outer Limits. I want to see just how bad they are.
-------------
How dare you vanquish the Steel Phantom without his consent? Fear the Phantom's Revenge.