there is well forgotten middle ground - large and relatively slow (say 200-300mph using today's tech) plane, something like this https://en.wikipedia.org/wiki/Dornier_Do_X
That's amazing
https://www.indiatoday.in/india/story/asaram-bapu-rape-accus...
The distribution of pax and baggage are chosen so as ensure its within the range. IOW, they don't book Row 1 then 2 then 3, etc, — sold seats are sprinkled across the aircraft as it's filled.
I've been told when the flight attendants are moving forward and back with the beverage service you can watch the trim wheel turn as the autopilot maintains correct AOA.
Maybe it'd be possible to revisit nuclear powered aircraft? Modern, intrinsically safe reactors powering turboshaft engines could keep a ponderous flying platform aloft for months at a time.