But as far as I can see, that lens (assuming the default 6mm lens offered with the module) will give you about the same effective resolution as your standard webcam, with maybe slightly better control over depth of field, far worse image distortion near the edges, and no autofocus.

The cheapest 6mm lenses that come even remotely close to using the sensor resolution start at 400€.