The smaller the focus of a convex lens more will be its magnifying capacity, so why don't we use magnifying glasses with very small focal length?
One would have to hold the magnifying glass to close to the object.
We don't use magnifying glasses with very small focal length as one would have to hold the magnifying glass close to the object to get the required magnified, erect and virtual image.