200$ is bit tough limit, so P&S with good macro and small zoom range probably would work best. Make sure it has manual mode, to set exposure , ISO and focus manually (best with focus ring). Tripod is a must, and then you can use my led trick to save on lights. 95% of photos you see I do with LED and exposure 2-10 seconds.
Once you grow out of this gear (which may take 2-5 years), then you get real 1:1 macro lens in 60-105mm range and either Nikon or C system. Sony and other systems are less popular (harder to get good lens cheaply) and often need some flimsy useless adapters and stuff.