Welcome to FlyerTalk, bradmoss!

My 2 cents worth (or maybe today you get the same value with only 1 Rappen ):

IME, emergency door rows are always desirable on a long-haul Y flight, and if you want a window, the 748 (and 744 and A380, if applicable) typically have one row with a window seat immediately behind the emergency door that offers a window, extra leg room, and access to the aisle. Depending on your elite status and/or threshold of pain for paying extra for those seats, they can be easy or hard to reserve.

The downside to these seats is that they are typically close to a lavatory, so they can be noisier (and occasionally smellier) than seats elsewhere.

If you are particularly motion sensitive, as you move further back in the Y cabin, you also move closer to the horizontal control surfaces and further away from the aerodynamic and mass centers of the vehicle, so the more sensitive and observant passenger will be better able to experience and appreciate both the short-period and phugoid tuning selected by respective Boeing and Airbus designers for your particular machine . In turbulent conditions, this effect will be more pronounced.