Sorry, Matt, about your loss on the Fitz. I knew no one on it and that song still grabs me by the heart. Nevertheless, for those not quite so close to the situation, that museum is excellent. Kentucky Joe, I do recommend you visit it.
The UP is big enough that you'll want to have at least 2 base camps, one for the eastern end and one for the western. One in the middle, if you have the time, would be worth it as well. Though it's been a few years, we have enjoyed stays at Tahquamenon Falls SP, Indian Lakes SP (the western section is a gem - very wooded, not as popular as the eastern as it lacks 30 amp & showers, but does have 20 amp hookups) and McLain SP on the Keweenau Peninsula. For the Soo, if you can get in, the Aune Osborn county RV park is great - not much to look at but has decent facilities, hookups and an unbeatable view of the boats traversing the Great Lakes. It's fun to watch them go thru the locks as well; there's a grandstand built for that purpose in town. For Pictured Rocks, we camped at a private CG - something like Wagon Wheel (I have forgotten the name) It was adequate and had some nice wooded sites.