Can't help on air con - we are on the lookout too.
But we do have one of these which is pretty decent - the misting helps cool you down.
Shark FlexBreeze
Our daughter is autistic and can be extremely sensitive to how things feel and sleeps fine with this blowing towards her on the lowest...