I love Fort Wilderness! It absolutely is the best campground in the country. I'm constantly using it to measure all other campgrounds by, and nothing ever comes close. Close to the magic or not, it is fantastic!
We only have a popup, but my parents have a 40-something foot motorhome, and have had no problems parking or getting in and out when they've stayed there. There was a refurbishment several years ago, and all of the premium sites have a large paved pad to accommodate larger trailers (I think they're 60 feet long). There are premium, preferred, and full hook up loops. The preferred loops are 100-300, closest to the marina. 400 is a great location: a premium loop just a short walk from the marina/settlement depot/ Pioneer Hall.
I agree, the sites themselves aren't very large or private- but there is a great amount of landscaping and trees.
Last year spring break, we took the week to do a non-parks trip. We spent the entire time relaxing and taking advantage of recreation (boating, swimming, fishing). Of course, being in the center of WDW was a nice perk; we traveled around the resorts and took advantage of dining, and caught the Electrical Water Pageant and Wishes from the marina each night.
I wrote up my review on the KK blog last year (
here). I really can't say enough good things about FW!