I do a lot of macro photography and have the Nikon 105 mm/VR "Micro-Nikkkor". It readily produces images of the type in your examples and is a superb lens in every respect. Here are a couple of sample images:
From reviews I understand the equivalent Tamron is also excellent.
Although you probably are not interested, I also have the Sigma F/2.8 180 mm macro which is optically as good as the Nikon and affords even greater working distance. A drawback is weight and - it is quite costly.
The real challenge in macro photography is vanishingly shallow depth of field. Focus stacking works wonders (I use "Zerene Stacker" but you need static subjects - won't work with bugs crawling around.
flash combined with small apertures can improve DOF but the bugbear of diffraction intrudes.
Best wishes,
JH