I got a revolver for my first restricted pistol. A dan wesson 6 inch .357 magnum. I also bought a six inch smith and wesson airgun that is almost identical in sight picture, and weight and trigger pull, and is also quite accurate.
I grew up watching dirty harry, so a magnum revolver was where it was at for me. It was only after I already owned the gun that I began to understand how much more versatile the wheelgun is. I keep going back to my first pistol and it always amazes me how much it can do.
I can shoot powderpuff loads, subsonic, monster heavy bullets, soft lead, jacketed little 95 grain pills that can be stoked to scream up to 2000fps, hollowpoints, wadcutters, wax bullets for fastdraw practice, blackpowder flash blanks that light up the twilight for cool pictures, shotshell loads with lead shot........ Dude, I even made up some really funny confetti loads.
Don't get me wrong, I love my automatics, but when I load for them, I need to stay within a certain power range to cycle the action or it turns into a single shot That includes the proper strength of crimp. They only chamber certain shapes well, round nose mostly, but sometimes semi/quasi roundnose hollowpoints. Also, most automatics very much prefer pricier copper jacketed rounds.It's not as bad as it sounds, it's just that for my automatics I find the most reliable load and stick with it. It's not less fun, just less involved, and handloading and bullet casting have become a part of the hobby for me in it's own right, not just to save money.
With my revolvers I can be free to find the most accurate load if I'm shooting for accuracy, or whatever else I want. I also don't have to pick my brass up off the ground which is nicer than you'd think when it rains or is muddy or it's in the winter.
I think you should get whatever type of pistol made you want to get into shooting in the first place, and who gives a crap about what is practical, or what you can compete with. This sport is about fun first, and you have years to get obsessed with times, scores and trophies, and you probably will.
But I wanted to give you an idea of the pro's and con's of automatics and revolvers. I own a precision single shot pistol, single action revolver, double action revolvers, target grade auto .22, 9mm luger, 1911 .45.....
I shoot them all regularly and each gun is a different shooting experience. It's all real fun, and having fun is what sport is all about.