I have the following RoH DVDs and I think they were all good shows:
Crowning a Champion
Glory by Honor
Main Event Spectacles
One Year Anniversary Show
Night of Apperciation
Obviously these are all from the first two years of RoH. Any show with a Steve Corino/homicide match will be worth it for that match alone. I don't have and cannot immeadiately recall an RoH show with a decent womens match.
http://rohwrestling.com will give you a match by match rundown on their dvds.