Since this is your first handgun scope I suggest you stick with either a low(2x) fixed power scope,or a variable that adjusts down to that power.
There are several scopes that would work for your purposes.
Leupold m8 2x,leupold variable 2x-7,weaver,burris,nikon are all good choices.The only time you will have scope turned up in power is shooting off bench. If you try it while hunting,it will seem to magnify wobbles.