Pros:
The main selling point of this course is simply the location. If you live in the Grosse Pointes, SCS, etc, you now have a DG course that isn't a 30+ minute drive each way.
The course itself is small and crowded with walkers but tries to make the best of its location. It does have concrete tee boxes on all holes and wooden posts listing hole number/distance for most (no hole maps, but it's so small they're common sense). The distances are varied, but all pretty short... 150-250ft with most under 200. There is really no need for distance drivers at all, and most players will barely even need to break out a fairway driver. There are 12 baskets, and there are two tees for each, so a "24 hole course." No water; a few trees but nothing overly challenging.
Cons:
This park is very busy with walkers and joggers (but at least no dogs in the actual park), and their paths go right across nearly every hole - even some of the tee boxes share the paved path. A lot of the walkers will give you a rude look or ignore you (even if you try to be friendly and courteous to them). I'm guessing they are disgruntled that DG moved in on their turf, but I don't think they pay for this public park any more than DG, soccer, or baseball players who use it? Nonetheless, it's a new course, so all it might take to close it could be a few rude players who PO the joggers or neighbor houses to the north.
If you play at "prime time" (approx after 5pm M-F or after noon on weekends), then your shot selection will probably be affected by all the walkers. You basically end up with the choice of "buzzing" walkers and risking the course getting shut down, altering your shot to avoid them, or waiting forever to tee off on some holes (esp #5 tee on the path... just tee off from the #17 instead). There are a few low walls that you could lose a disc over, but with such a short course and so many walkers, you probably won't be using much hyzer anyways.
Other Thoughts:
If you play DG and live near the Pointes, it's a whole lot better than nothing. In the end, the designers did the best they could given the park's popularity with walkers/joggers and the layout they had available. It's not very busy in terms of other DG players, so it's a good starter course. There was talk of possible leagues in the future, but I think the course is too small and walkers would protest it. I gave Brys DG course a 2 disc rating due to concrete tees and posts on all holes, being well maintained, and the good idea of adding alternate tees.
Overall, it's just too tight of a fit due to all the walkers nearby. The holes are short, and nearly all are an easy birdie for most players. Maybe one saving grace for this course is that it's a great place to practice your accuracy and using your midrange off the tee. You could easily play this whole course (well) with a Roc, Shark, etc type disc. It's a solid beginner course or a chance for intermediate DG players to work on their mids and putting.