Personally I’d vote for another Michigan locale (Isle Royale), but the Dunes are certainly a great candidate. Enjoy!
I have a good friend who used to camp there, he saw it as a tie between camping there and the Manitou Islands (offshore from the Sleeping Bear Sand Dunes).