We were at Mystic Dunes one year at New Years. The building is oriented so that the room balconies are facing in the wrong direction (at least in that building), but we walked up one floor and watched from the back balcony (where you normally walk). We saw fireworks from all the Disney parks, Universal, and somewhere downtown. You couldn't see the lower fireworks, but it was certainly quite a show.
Sheila