Having played around with the revolver on vet and psyker etc I found it fun to use but it really pales in comparison to everything else on offer. I DO have an idea where it could be better utilized.
What if instead of increasing the ammo, or capacity as many are suggesting to make it viable next to lasguns or bolters, you just up the damage and give a comically oversized version to the ogryn.