My wife and I own and shoot both a .38 Special/.357 Magnum revolver and a 9mm pistol. They have their pros and cons. For me, getting the right grip on the revolver is a challenge so that I can control it without also placing my forward hand near the front of the cylinder. I am still working on that. However, I still hit center of mass out to 10 yards. With the pistol my wife leaves me behind as she is deadly accurate out to 20 yards and I am reasonably good out to 15 yards. At 10 yards and less we make fairly tight groups. We also still work on our grip.
Revolvers can jam due to a case locking up against the back of the frame. Pistols can malfunction due to limp wristing, poor grip, or even ammo or magazine quality issues. Revolvers can be left loaded and reasonably ignored for periods of time with minimal maintenance. They also are dead simple to use with double action trigger pulls being basic level safeties to help reduce negligent discharges. Pistols can have external safeties that might be difficult to use under stress. Others might have less intrusive safety mechanisms but require more conscientious maintenance. Revolvers can give you a second chance to fire as it revolves on to the next chamber index if one round does not fire. Pistols can be quickly cleared if one is experienced.
What it comes down to is which you feel comfortable with, which fits your budget, and which is the best fit for your personality and lifestyle. Even the chambering you need can vary depending upon the intended use and tolerance to recoil. Even the ease at which one can open the cylinder or rack the slide can factor into the decision. If the slide cannot be easily retracted to chamber a round, perhaps a different model, design, or even revolver may be in order. The Beretta Tomcat has a tip up barrel design that allows the first round to be inserted manually without racking the slide, then it self loads all remaining arounds with each pull of the trigger.
As for preferences, the Ruger Security-Six revolver we have is nice, but so is the Sig SP2022 we have. To each their own.