One of my earliest memories as a toddler was of my dad coming home from work, the big revolver hanging from his Sam Browne belt, the line of cartridges pressed into the belt loops that were de rigueur at the time.
Fast forward a bunch of decades and while I can smile at the long history of RN revolver cartridges, if I never dropped another into a cylinder again that'd be perfectly fine. There are much better choices.
I shot a .44 magnum in metallic silhouette (distances out to 200 meters) for a bunch of years; and did a lot of load development in conjunction with that game. The nominal improvement in ballistic coefficient that a RN might give you over, say, a SWC at handgun velocities, at those distances, isn't meaningful. What you cede, though, is terminal effectiveness on pretty much everything.
A well-done SWC load will do pretty much anything you might ever ask of a revolver. HP and flat-point designs can work very well, too... albeit, not being nearly so versatile. I'd give the RN a pass.
And, yeah, you probably want to put aside any notions of using a plated bullet when you're looking for that perfect load. A hard-cast or jacketed design is almost certainly going to prove far more satisfying.