Over the years, I've tried virtually every brand of lube out there, plus some home remedies and "off the automotive and grocery store shelves" remedies.
Been there, done that also.
For straight wall handgun cases my personal experience has been that the wax base lubes are okay. I use Hornady One Shot and the plastic bag method with decent results.
For bottle neck rifle cases however, the wax lubes have not worked for me. That includes Imperial sizing die wax. Just bad Carma I guess, since I do know how to lube cases.
The water base lubes, in my opinion, still take too much pressure to insert and extract from the die. I believe most are wax based also.
For bottle neck cases, the absolute best lube I have found is Rooster CFL-56 Case Forming Lubricant. Not cheap, but a small jar will do several thousand rifle cases. A dab on your index finger the size of a pin head will coat five cases.
For lubing inside the neck of bottle neck cases, I use a possibly unique method that works well for me. I take a small glass bottle (about 1/2 ounce or so) and scoop in Imperial Sizing Die Wax until the bottle is about 20% full. I then add naphtha (available at Home Depot) to fill the rest of the bottle. Loosely cap the bottle and heat with a hair drier while shaking until the wax totally dissolves (about 130 degrees F). The mixture will be clear when all the wax is in suspension. You only have to do this once when your are first making the wax/naphtha suspension.
Dip a nylon bore cleaning brush in the liquid and lube five case necks. Dip again and lube another five, etc. Wait at least ten minutes for the naphtha to evaporate, and you will have a perfect thin coating of Imperial wax on the inside of the case neck. Imperial will not contaminate the powder or primer, which is why I use it inside the case.
The Rooster outside and Imperial film inside makes for wonderfully smooth case resizing.
I do use single stage presses, so the above suggestions may not be totally appropriate for you.