I've had one for many years.

The tablet is not what gives you detail...it is the software you choose to work it, IMO.

Mine is a Wacom. Not a very large one.

Here is a portrait I did of Sheba long ago.

And I did this nest with another program I had back in the 3.1 days:

And the third one was a design I made on my current program for the other forum I used to volunteer at. Sorry if it looks like an "ad" for there, but be assured my efforts were not appreciated either.

The program I have now is pretty old, but it is called Jasc Paint Shop Pro 9. The graphics programs allow freehand or point to point drawing. Freehand always creates some pixels...but if you use the proper layers that can be avoided. Point to point drawing is alway clean.

I prefer using real hand and paper, so I never really took to the graphics style. But it can be very fast if you do design work, etc.
You can scan in things and add to them, all sorts of fun. But it is your software that determines what you do with the tablet.