Hello Nick!
It sounds like you really enjoy a good challenge! The revolvers I can recommend would only be available used (with the possible exception of the S&W).
S&W use to make (maybe still makes) the model 940 "Sentinel" that fired the 9mm round, but I think it required a full moon clip. This was a "hammerless" (non-exposed hammer) with a snub nose barrel.
Ruger use to make the Speed Six revolver in 9mm, again, I do not know it it required a full moon clip or not. As I remember, it had been available with a 2+ inch and a 4" barrel with exposed hammer.
Colt made a variant of the Commando (a parkerized Lawman Mk III) that fired a major collection of .38/9mm rounds (up to 18 different rounds) interchangeably, but I do not know if it required moon clips or not ... a revolver that digests that many rounds has appeal, but it makes me suspect!
Honestly, I am not "up" on the current production 9s, since I am more inclined towards rifles and my current crop of handguns.
Good luck and good shooting!