It depends what you what to achieve. A crude rule of thumb is that for cooling, but not much lubrication, use soluble oil diluted with water. For lubrication, but not much cooling, use a neat cutting oil. These often have EP additives for operations like gear shaping where speeds are low, but cutting pressures can be high.
All the fluids mentioned seem to be aimed at tapping rather than flood coolant for general machining.
I often machine dry, but when I do need coolant I use soluble oils because I need the cooling function, and I always use flood coolant. Dribbling coolant onto the work really doesn't achieve anything. I used to use Biokool14 from Hallett Oils, but now use Hysol XF. And to forestall the expert comments, both sit in my tanks for many months at a time without causing smells.
With regards to the fluids mentioned I usually hand tap dry. For more difficult hand tapping (stainless steel or taps over 1" diameter) I use a Rocol grease like tapping goo. It works very well but can be a PITA to clean up, which is why I use only when necessary. Machine tapping on the vertical mill is done dry, on the repetition lathe I use flood coolant, simply because it is there.
Andrew