Yes, it can.
I don't think it's possible to truly rate coasters on a "top 10" style scale, due to all the variables. There are some coasters which ARE incredible, but don't hold up for re-rides because they really hurt or are just incredibly hard work to ride.
One example of a ride that's just hard work would be Voyage, and I'd say that actually stops it from being as good as it could be. If the ride was shorter it would actually be better. It's not painful though.
With regard to pain, I've never ridden anything which quite comes close to SkyRush. It's an amazing ride, a breathtaking, incredible, terrifying experiance, but something was just stopping it being "a really good coaster". I think it's a combination of the pain and the fact you have to work to avoid it and that being forceful is not the only measure of a good ride. There is such thing as too much. I think SkyRush is treading dangerously close to the threshold before negative g force just becomes awful.
I liked SkyRush the more I rode it, because I learnt how to ride it. That's backwards to how most coasters are. Ultimate, for example, was incredible the first time I rode it and has progressively become dull because I understand how to not get hurt.