I was the pro for seven years at just such a club.
Heritage Club, a PB Dye-designed course outside of Cincinnati, Ohio, is very difficult. There are eleven holes with either a red-staked lateral hazard, a yellow-staked water hazard, or both. On six holes, multiple shots must negotiate hazards. In addition, greens are small and undulating, and on sides of holes where it allows, grass that grows about four feet has been planted. It is very, very easy to lose a golf ball there. Even for a skilled player, it is a challenge to play eighteen holes and not post a double bogey, because there are so many spots where you can lose a ball.
PB even came back a few times after it opened to soften it up. Now, we had a very good membership, especially for a market the size of Cincinnati. But, I played with prospective members quite often, or people who may have won a gift certificate at a charity outing, and many, many times I heard some variation of "Boy, I wouldn't want to play this course every day."
It's a good, solid golf course that tests every club in your bag...not nearly in the same league as Camargo here in town, but what is? But, it is very difficult, and like I said I know from experience some guys said it was too difficult to play every day. However, we found guys that did want to play it every day (it only takes 300 or so), so the club did, and continues to, do very well.