<someone's got a little Attitude going>
I won't recommend any particular firearm, instead I will suggest that you go down to that apparently friendly gun shop where they are willing to let you test a few. Go there and try out several options. Try a .38 revolver, try a .357 revolver, try a 9mm semiauto, see what else they have, even try different brands of the same format (.38Special revolvers from S&W, Ruger, Taurus, Colt {if they have one there}, for example). All the suggestions in the world won't mean much until you actually shoot a few of them. And have the store staff show you how to handle the firearm, how to utilize any safety devices they might have, how they suggest (which you will verify on your own later) that you carry each one relative to any employed safety devices on each firearm, and in particular ask them about the Glock trigger system and decide if that's something you can deal with or not.
For semi-autos there are double-action only ones, and ones where the first shot can be double-action and then single action after that, and there are single-action-only semi-autos such as the Colt 1911 formats, and then there are the Glocks.
Personal preference, reading, training, and on the job experience will guide you from there.
Me, personally, I like revolvers, and I like semi-autos. I've used a Sig-Sauer P220 with the double action first shot and liked it just fine, even with the Euro bottom magazine release clip. I've used a Browning High Power and liked it just fine. I've used Colt and S&W revolvers and liked them just fine, even though I have a personal preference for the Colts.
I have no idea what state/city/country that Axelar {note proper usage of the capital A there} is from, which in and of itself could greatly influence his eventual selection. And since he (or possibly she) is also talking about using the firearm for offduty use then his personal preferences should carry a stronger factor in his decision making process.
And as to the Barney Fife comment above, these days the Barney Fifes of the world are more likely to be carrying a semiauto than a revolver, and the old dude by the door with the ancient revolver in his holster just might be able to shoot the eyes out of crows at 50 yards any day of the week. Don't let urban legend and attitudinal assumptions sway the decision process, too many people have died making bad Assumptions.
Just my opinions, take them with a grain of salt, flavor to your personal taste.