For longer flights, the decision largely revolves around your height, and whether you can keep your antsy tendencies at bay by sitting for prolonged periods. For taller people who like to move around, sitting in the aisle is recommended, mainly because you get to stretch your legs and exit the plane more quickly after landing.
But for those among us who enjoy sleeping, the window seat is great. You're basically in your own universe here, as no one has to bother you for anything. But the pitfalls come when you have to go to the bathroom, as everyone in your row has to move for you. (It's practical to stay light on the beverages in this regard).
Pick Your Aisle Seat Next to an Empty Middle Seat
This strategy doesn't guarantee success, but when it does work, you'll feel like a genius. Vadocz reasons the gambit has a 10-15% chance of working, but he always books an aisle seat next to one that's empty, just in the off chance that it's never filled. Since airlines automatically book Economy from the front to the back of the plane, the likelihood of lucking into this situation increases when you book at the back of the economy section.