I went with a legacy manual macro lens. There were TONS to choose from at varying prices. So I found one in good shape and made an offer on eBay, and the rest is history.

I picked up the Vivitar Series 1 90mm f/2.5 Macro and the 1:1 adapter for it. I guess this lens is known as the "Bokina"

The lens by itself will give 1:2 (which is good for most work) and the adapter will make it 1:1 for super close stuff.

The sensor size on the NEX-6 makes the effective focal length 135mm with this lens.

This setup should be flexible for both portraits and macro. I paid not much more for the two part lens system than I would have for a magnifier or power extension tubes.

I just need a Minolta MD-NEX adapter (about $20 on eBay) and I am set.

I bought the hotshoe flash for the NEX-6 so that will help, along with the light box. I may look in to a flash ring or a slave triggered flash in the future.

I will update everyone on how it works out when I get home! Thanks for all the input.