I haven't used any warming lube I've loved but they're all felt warm, not just tingly - ky and wet together.
I have been told by my boss ( I work in an Adult store) that warming "anything" is not really safe to use as a lubricant. It is good for massage and men like it on them for masturbation. But men are skin where they put it and women are soft tissue on the inside. It can actually cause damage. Female arousal gel or creme will give a tingly sometimes cool feeling that alot of women like.
Just wanted to share that.
When I went into the store to buy warming lube I was given the warning that LolaG stated, it can cause damage and really should only be used in solo play. Just thought I would put it out there. I bought a bottle and I use it some times during solo play, but it just tingles a little. I did try it once during actual play with a partner, it wasn't great, somewhat tingly but not much. I much prefer regular lube myself...