Pros:
I heard about a tight bayou course near downtown Houston from a skater friend, and when I had the opportunity to play it on a trip I definitely made it happen. I also brought several newbies who live in the neighborhood (and who I'm sure will be returning in the future to hone their skills).
The term "bayou" as best I can tell means something like "stagnant creek," or what looks like a creek or small river but doesn't actually flow unless there's a ton of water coming down the small valley that it sits inside. Needless to say, the bayou water hazard here, rimmed somewhat by medium-sized trees, are the nastiest looking soup I've ever seen in a disc golf course. The soil is very sandy. You can see sand spit up when the disc comes down even in grassy areas.
The valley around the bayou water is very nicely groomed and mowed, there are steep side-slopes to deal with on several basket placements. There are plenty of trees to provide obstacles, though many are still young. (I think it they didn't mow the grass regularly, it would be a jungle in here!) The view of downtown is quite spectacular from the course, and a very unique setting for disc golf.
Most holes on this course require very good control on your throws. If you overshoot, turn over too much, or fade too early, you will seriously never ever see your disc again. Period. It seems like wading in that water will get you a tropical disease, or eaten by a gator.
Hole 5 was my favorite on the course, with the big bayou water hazard running along the right, and then you have to play through a tight tunnel across a small muddy tributary and ditch that is probably about 300 ft away from the tee. Most players will lay up on this one, but if you're confident, then hitting this tunnel and parking for birdie will be one of the most satisfying throws you will ever make. But, if you hit something going across, another great chance of never seeing your disc again, unless you're lucky enough to get a floaty.
Huge arms (400+ ft power) can power over the top of some of the tree lines on this course, which might reduce the challenge somewhat, except that the baskets are often on steep slopes so getting the disc to stay put is not at all simple. And you really do have to be flawless in your aim if you're putting more power on your throws.
Cons:
A lot of the baskets are of the cheap, single-outer ring style. Some are deformed/bent, and I don't think they will last much longer. They need to install Mach V's or similar. Dirt tees are sometimes not smooth. Be careful, and watch your step! It is also not easy to navigate the first time around (start on the backside of the skate park, opposite Sabine St).
Car break-ins are rampant in this area. I heard tales of discs and other items being stolen from cars parked in the neighborhood, and saw a person discover their car window smashed when I was there. Be careful, lock your car, and don't leave anything in view.
There is some pedestrian traffic, but I found them to be friendly, and curious, often stopping to watch us drive from the tee.
Other Thoughts:
Bring mosquito repellent. The bayous are huge breeding grounds.
This course could easily be expanded, also for special tournaments or other events. This bayou continues for a very long ways, and the park land is very nice the entire length.