TS... what is the brand of your camera. Without even telling us this basic info... how to you expect us to advise you anything that is very accurate.
Since we have no idea what is your camera brand, I think we can safely say that you do not want to use your brand's own macro lens for whatever reasons, so there is quite a number of lenses and brands that you can go into.
1) Tokina - 100mm f2.8 (it don't have FTM though)
2) Sigma - 105mm and 150mm
3) Tamron - 90mm and 180mm
or,
you can add extension tube and/or closeup filters like Canon 500D (not to be mistaken for the camera itself) and Raynox.
or,
get yourself a macro coupler and do some reverse lens shoot
or,
get yourself an adapter for you to stack lenses.
Also don't forget to get yourself a good external flash with diffuser too.