A revolver is not your normal CCW gun unless you go with a 5 shot snub nose small frame which is okay for close encounters but that’s about all. As you explore and experiment you might find that one gun does not fit all occasions. that is why many gun owners own several for different occasions and applications. Guns are like tools to a mechanic, one wrench does not fit all unless you only have one nut to turn in the same location. Take your time and explore all the possibilities.
In NY, anything other than a close encounter shooting will put you in jail for a long time. FYI -- Although I have several semi-autos, I carry a Ruger SP 101 2.25". With practice, it is accurate enough to hit center mass at 25 yards.