I am glad when i get exit-row on long overnight flights, but for everything else i tend to prefer a window seat in a "normal" row.
The reason is: On overnight flights i just use the space in front of my seat to lie down and sleep curled up on the floor. 90% of the time i get no objection from the staff.