I asked steve david the same question and here was his reply
Water viewing is pretty difficult, they keep you about 1/4 mile up from the course towards Lake St. Clair. Best viewing is from deck of Roostertail lounge or the docks at the Detroit Yacht Club if you have any member friends there. Alternatively, they have grandstand seating next to the pits that has awesome viewing. Thanks for writing Scott.