What is the most comfortable bike frame material for very long rides?

The frame material doesn't make much difference. The important thing here would be the frame shape and weight, the seating material and shape, what tires are being used, and what, if any, suspension the bike has, as well as what sort of handlebar grips it has.