This is a "there is no free lunch" thingy.
Close up lenses typically have terrible aberrations, which you can't conjure away by bending the film or shifting focus.
You will get far better results using extension tubes (even with a standard lens). A special macro lens would be even better.
But they cost...