But out of curiosity, given that the ride is smoothest over the wings and rougher in the rear of the cabin, would the ride be equally rough in the front as in the rear if we make the rough assumption that the wings are midway down the fuselage?
That would probably be true if the fuselage were rigid. However I have always thought that the effects of rudder and elevators, combined with the (small amount of) flexibility of the fuselage made the back end move around more than the front end.