You are going to have more chances in upper clubs. Try to talk to the girls, a Gringo is always welcome. Or you'd better go to Vallarta since you are close. One more thing: Don't you go to 'Los Altos', a number of small mountain towns around San Miguel. Girls are pretty (White, petite and nice) but very, very conservative. It's a waste of time. You can even get bad responses from locals since a foreigner is 'try to steal' a good Mexican girl.
With God's help, I'll conquer this terrible affliction.
By way of deception, thou shalt game women.
Diaboli virtus in lumbar est -The Devil's virtue is in his loins.