Mo,
I m a died in the wool iron sight shooter when it comes to handguns, so please take everything I say with that in mind. Yes, a red dot type scope works very well on a a handgun, almost any handgun. This is because it puts the sights and the target on the same focal plane. You no longer need to worry about aligning the front and rear sight and then placing them on the intended target. The same is true of a traditional scope. Probably the biggest issue with dot type scopes is that you need to be aware of the dot size and make sure that it is suitable for the distances you ill be shooting. The dot will cover a larger portion of the target as distance increases. The dot is normally listed by the size in minutes of angle. A 4MOA dot will cover four inches at 100 yards, eight inches at 200 yards, etc.
A scope with magnification will also magnify any movement of the gun, and at high magnification, can be almost nauseating. For this reason I would recommend low magnification, probably no more than 4X, unless you are shooting from a very solid rest. Too high of a magnification will also make it more difficult to shoot those deer that walk to within 10 feet, as all you will see is hair. At high magnification, the target fills more of the field of view.
I can't tell you what is the right answer for you, but hopefully, the above info will help in making your decision.
JW