RMBA,
Just some observations from 30+ years of Canadian fishing trips...
1. There's a strong relationship between how nice a camp is in creature comforts and how depleted the fishing is in the immediate area. There are some exceptions, but generally if you want fine accomodations and food plans, don't expect as much from the fishing. It will still be better than Wisconsin though.
2. Many lakes take time to reveal the seasonal fishing strategies that work best. Don't expect to learn all these on your first trip. In many areas hiring a guide is a good plan the first couple days out.
3. You mentioned wanting a drive in camp. Another option, without the cost and limitations of a fly in, is a boat-in camp. These offer the exclusion and low pressure fished water of fly-ins at a lower price and no weight limits on gear. My group has used the Sturgeon Lake Lodge Outpost with great success since 1983. At this camp you load your gear onto a tug boat which takes your party (and tows your boat)22 miles to a single outpost cabin. Of course, at boat-ins like fly-ins you are on your own, and must develop good fishing techniques exploring the available water.
4. Wherever you go, realize that fishing action varies year to year, and that the place where the action was tremendous last year might not be so great this year. Water levels, temperatures, hatches, and some subtle factors affect the action.
All things considered, you will have a great time. The wilderness is awesome and the fishing can be fantastic.
GovMan