quite honestly you can use any mouse for any task. how well they work for that task really depends on how comfortable the mouse is for you to use.
so-called mmo mice are just mice with a grouping of buttons on the side. there are certainly other styles of multi-button mice available but products like the naga, naga-hex, g600, etc are what are normally thought of for this style.
everyone has a different hand size and idea of what fits their hand the best. the first thing to do is get a mouse that fits your hand style and grip style. be it palm, claw, half-claw, fingertip, etc. next would be to find a mouse that fits your needs (buttons, needing to lift the mouse, etc) that fits in with both your grip style and any ergonomic concerns you might have.
it is honestly hard to say if a product will work for you without testing. it may take weeks of use to get used to a new product to correctly judge it. this, however, is often longer than return periods so it makes judging such things hard the best i can say is to give a product a solid few days of constant play to see if you feel you can get used to or learn how to use it. note any problems you might have. in the case of learning the buttons, you might be able to overcome that with practice. in the case of physical pain in pushing buttons or using the mouse, quit immediately and buy a different mouse with better fit for your hands.
--
this section is personal opinion. yours may vary, take it with a grain of salt.
my personal thoughts on mmo mice are that i do not like them. i have tried the g600 and did not care for the keypad on the side for two reasons. while agreeably it requires a bit of muscle-memory and practice to get used to such input (there are many people who like such mice) i found myself thinking more about pressing the right button than being able to seamlessly play the game. i have also used mice like the g502 and found the learning curve to be steeper on grid-style mmo mice than the more unique placement on some other multi-button mice (albiet they do have less buttons). the other problem is comfort. a part of that is i like gripping mice on the sides to pick them up if i reach the end of my pad which you can not do easily without hitting the buttons. the other part is that to hit all of the side buttons correctly my thumb either had a hard time pressing the right button or was at a strange angle which i felt was less comfortable.
i have had a short time experience with a naga hex and while i would say i liked it better than the g600 placement it was still awkward for me to use.
the logitech g502 i tried out which had more buttons than my deathadder was surprisingly not bad as far as button layout was concerned. muscle-memory and hitting the right key was a little easier and the buttons were comfortable. i would have kept the mouse but the width was a little too narrow for my hands (i'm used to wider mice) and i did not care for that style of scroll wheel.
what do i generally use?
i very much like using my razer deathadder. while it may not be a high button volume mouse it is easy to use and is comfortable for me. comfort trumps any advantage a mouse will give you. as far as hitting skills for mmo games i play with either a keypad (tartarus) or arrow keys + numpad based fingermap. as long as skill chains and bindings are not stupidly excessive this has worked out well enough.
as far as fps games, simpler mice seem to be a better fit for me given that i need to swing the mouse around by lifting it up at times (depends on the dpi/speed settings you pick.. i prefer medium swings for more accuracy control) and simple easy to press buttons since more keymappings are generally not needed. most can easily be keyboard based.
end, opinion
--
not sure how much that helped.