This may seem childish, but it depends on the route for me. If I know that I will be descending through beautiful scenery I might want a window so i can catch a birdseye view. Also, on short flights I prefer the window and also on night flights.

Here are some examples of places that when flying into I would want a window seat:

HKG PMO
HNL LIH
GVA KOA
FCO SFO and any place that I have never been to before !!!!