I find Dragon's Fury really hit and miss. If you get a good spin on it, it's a superb ride. If you don't, it's just really long and meandering and doesn't really do anything exciting. I like it because it actually has a decent length, but it's a bit crap after the second lift too which kind of ruins it.
Sonic Spinball I find the same. A good spin and it's brilliant, a bad spin? It's actually still a pretty decent kiddie coaster actually. The compact nature of the ride makes it still a little intense and fun. So with a good spin, DF is the winner, but generally, Sonic Spinball generally wins out.
Whirlwind at Camelot was okay I found. A bit jerky, but nothing obscene. Dull though and I never felt any compulsion to re-ride.
The Gerstlauer one at SFNE was okay too I guess, and I enjoyed being sat facing inwards, but it didn't really do very much.
Tylorean Tubs (or whatever they're called) at Joyland made Whirlwind seem like a soft mattress.
The Reverchon spinners (and their ilk) I actually quite enjoy in a way. In a "it's not bad I suppose for a kiddie coaster mixed a little with a bit of Waltzer action". I don't make any effort to ride them though if I have to pay for them, but I'll go on them with CF or the kids if they fancy it.
So yeah, probably that order. I can't remember the Virginia Reel at Blackpool, so no idea if it was good or not (or even if I rode it - though I suspect I did).