Find a range that rents guns. Go the range, find a weapon you’re happy with.
Personally, I’d ditch the Auto requirement and go for the Ruger LCR. Its light, comfortable, easy to use, and safe. The .38 is a perfectly adequate round, especially with all new fangled ammo they make in that caliber. If you get a concealed carry permit, it is compact, easy to carry and easy to bring into action.
Is the Ruger LCR the newish 9 mm carry semi from RGR? Do you like it?