Depends eh, I'd think going for Photoshop, SAI etc are more efficient and effective in art making.
Drawing in MS Paint is like, showing off the skill one process? But I bet it takes extremely long time to do so...
As for the quality of a tablet, I think its just up to buyer's financial capacity.
But yea, making good art doesn't necessarily need a top notch tablet. Wlop (a digital artist) for example, using a Wacom Intuos, I consider that a mid range tablet but is still capable of executing his art nicely. But then again, top notch tablets are often convenient and pleasing to work with. :>