I wonder how many of our members use the same camera ? Not many I guess.
For good images, you need a good 'Macro' or 'Close-Up' function.
A lot of people will state the amount of MegaPixels make a better camera, however albeit this is true, as the more MegaPixels you have, the better the quality the image will be in terms of detail, this can backfire on you, depending on you painting ability.
If you a flawless, professional miniature painter, a camera with a high megapixel rate will show off your creations to a stunning effect, however, if you are a beginner/moderate painter, the higher the megapixels, the more chance of your camera will show all your painting faults when using the Macro function.
Any camera needs time for the user to practice what works best and each of our members can only give you their own experiences with their own cameras.
Use any decent camera to photograph the MonaLisa, and you get the MonaLisa...use any decent camera to photograph a dog turd...you get a dog turd
If your painting skills are not fantastic, my advice is not to go for extreme close-ups !
Overall in answer to your questions, any camera will do with a good Macro setting...you just need to learn how to use it to get the best results.