No way window seat for long flight – tourists !
Anything more that a couple of hours and aisle seat is key, you can get up and walk about as much as you want without annoying people, and have way more leg room, not that I need it mind.
Drink loads of water and the aisle seat becomes even more important.
If you really want to see the view buy a book called Earth From Space. You only get to see it at landing and take off anyway after that you will ba above the clouds.
Actually this reminds me of an unresolvable argument with old bf, he always wanted window and I like aisle. Fine, in the end we just sat separately. Says it all really…