We just spent a week in northern Michigan where the bugs were FIERCE. Every cousin and my kids looked like they had chicken pox on their legs. It's a really bad year up there. And we used bug spray religiously.
Based on our reluctant scientific testing with our own bodies :-) and trying multiple products with DEET, including sprays and lotions, I can report that the classic Deep Woods Off was the best. Spray, because then you can get it on clothes, although the wipes are great for less buggy environments.
Also, those foggers they sell for the yard really do reduce the bugs a lot (we were finally driven to it at our family outdoors get-together). If you're going to be in the woods or up north somewhere, bring long pants and lightweight long-sleeved shirts.