We tried this with some 1 or 2 mmorpgs: Vanguard (gag!) and my friends played Final Fantasy (gag!) for about 2 months and I think they tried it there too.
COMPLETELY UPDATED: See reply further down for updates
What I have is a Playstation 2 controller, hooked up to the computer using a USB connector from Radio Shack.
I play a rogue, a young one at that. So I do not have any where near the amount of skills to readily use that a caster or anybody high level would have. But even so I got the controller to work pretty well to go out for a hunt.
So far I've got the mouse and mouse1 as part of the controller so you really can just sit back and relax. I'm probably going take it out though since it's not really that big of a deal for me to grab the mouse. If I was chilling on the couch, this would certainly stay though.
I've divided the controller up into 3 sections, holding down Control, holding down Alt, and not holding anything down. I have room for more buttons if I were to add shift and start adding things like Shift + Alt + F1 = Spell Up Macro. If you try this, I recommend using Control as one of your toggle buttons so that you can use Psinet's Atlas feature.
UPDATED: I adjusted the sensitivity of the analog stick. The next paragraph is no longer an issue. It frees up the other directional buttons for use of more buttons.
\\\\One more thing to note, the left analog stick is set to 4-way diagonal. It ignores N,E,S,W. I tried it using all directions but it was way to sensitive. Writing this now though I bet I could adjust the sensitivity way down and make it usable for all directions.
Images: