Thanks. I am deciding on a 60mm or 100mm prime macro. I have the Sony NEX-6 (which is a mirrorless with a large sensor) and there is only one 30mm prime for it right now ($350). I will likely get the adapter and maybe a Canon or Nikon legacy lens and just manually focus it. I can get a decent used glass and adapter for a couple hundred bucks, or less.
I have also considered using tubes as well, but I am not sure if they will give me the results I want with my 16-50mm kit lens.