Something I hadn't thought about much until reading this thread is just how much the degree of a reverse camber can vary.
My first thought was that I hadn't played many reverse camber holes. But as I'm thinking about it, multiple holes at my home course could be considered at least mildly reverse-cambered.
Our 4th hole is a drivable dogleg-right uphill par 4, where the left half of the fairway falls away into a depression. A solid tee shot of 220+ yards has a good chance of finding the flatter portion of the fairway nearer the green, but the player who sends their ball left will get shunted off into the valley and out of position. Unfortunately, some trees on the inside of the dogleg make it very hard for a shorter hitter to get a clean shot from the uphill-but-uncambered right side of the fairway, although those same trees push a lot of bigger hitters out to the left and toward the depression they need to avoid.
Similarly, our 7th hole is a very uphill par 4 of about 320 yards. While it doesn't really dogleg, it does set up for a right-to-left tee shot. And again, a side slope also is strongly in play through the fairway. Balls hit to the left third off the tee will leave an uncambered stance (you're still hitting uphill, but the ball is level with your feet). The further right you go from the tee, the further you need to hit your tee shot to avoid getting shrugged off down to the right.
And our 15th hole is another par 4, around 400 yards. Again, it doesn't really have a pronounced dogleg but gently curves right-to-left. And again, the right side of the fairway falls off more suddenly and abruptly than the left side of the fairway. This is one of the holes where you're most likely to hear a playing partner call your shot a "good ball" right before it lands and bounces straight right into a spot that's totally out of position.
In each case, there's a dose of precision required of the tee shot. And in the example of hole 15, the little bit of reverse camber is an architectural unicorn - the rare feature that actually makes the hole tougher for the strong player to negotiate than for the weak player. It's the big hitters who can reach the portion of the fairway that's reverse-cambered, while the weaker player gets a wide, flat landing area in their driving zone, and even in the final 80 yards or so if they're laying up.
I also think reverse camber works really well on reachable par 5 holes. One of the first courses I ever played, Wild Turkey Trace in Lawrenceburg, KY, has a pretty cool par 5 for its 14th hole. Dogleg right, routed across a right-to-left slope. Reachable with a big drive, but it's a hard fairway to hit and hold, and everything about the second shot calls for a fade while you're hitting off a hook lie. It's a hole that absolutely works, and you can play it for about $15 if you walk.