Hi Kel. I've done a lot of Tahoe research since getting no responses after my original post.
My MH is 39', and you are correct about the length limits at Sugarpine. Many of the smaller CG's have similar limits.
Campground By The Lake does accommodate larger rigs, but sadly they are already booked up the entire month of July.
Another option was Tahoe Valley, but they are extremely expensive, despite the bad reviews they get on RV Park Reviews.com.
Unfortunately a Tahoe trip is not looking do-able for us at this point.
2005 Fleetwood Providence 39J
CAT C7 350, MP-8 Programmer
My wife does all the driving - I just hold the wheel...