So I made it to my destination of Wendy Park in Cleveland. It is lined up on the approach path for the Burke Lakefront Airport. This makes it a decent vantage point for the air show there. It's not great though.
It was pretty cool watching from Wendy Park but obviously the views would have been better at the airport.