Is a 40 foot fifth wheel too long to access neat places?

Not the answer you want to see, but of course size does matter. Suitable site availability drops rapidly as you get bigger. The situation is not helped with many NPs & SPs being non size selective sites so a CG with 50 sites but only 5 suitable for 35' or so rigs may have them occupied by class B or C rigs leaving many smaller sites unoccupied & unusable by the larger units.