I've been coming to Detroit Lake every Labor Day weekend my whole life and enjoy it every time. On a holiday weekend it can become busy and between the wind picking up in the afternoon and all the boats, the lake can turn into a choppy ocean. But it's still a beautiful area with a great mix of nature and amnenities. Close to Salem and Portland too. It's actually quite peaceful on a non holiday. Especially if you manage a waterfront site. There are a lot of spots that back up to the highway and you can definitely hear cars, but still enjoyable. Many of the spots aren't huge, so keep that in mind if you have multiple tents, etc. It is a State Campground, so at times it can feel like there are a lot of rules, but take it with a grain of salt and you'll have an enjoyable experience.