I always want a window seat. Even if it's mostly dark or above clouds in the middle of the flight, you can usually look out at the beginning and end, at least.

And on a less scenic reason, in a window seat, you have a wall to lean against during the flight, which is another perk.