It's true that long or short barrels, slower powders give highest velocities.

The trick, the thing I believe you're asking is, how can I make an efficient load for a lightweight, short barrel revolver.

Powder burn efficiency is increased when near to maximum loads are used. IOW, loading anything light decreases efficiency leading to unburned powder, soot, etc.

A full burn eliminates most issues.

Recognising Newton's Law of equal and opposite reactions, the faster the bullet moves, the greater the recoil.

So for your purposes, a bullet in the 800 to 900fps area is optimum.

It IS a big bullet after all.

Using a faster burning powder at an efficient loading, say W231/HP38 for example, would be ideal for your purposes.

I like a 250g SWC over 6.5g W231, but you could work up to that. I figure it to be @ 850fps from a 4" 624.