Have you considered rows 45/46 on the B747-8? It's at the rear of the aircraft, where the fuselage narrows down and the seat pattern chages from 3-4-3 to 2-4-2. So you could have a row with a window and aisle without the 'threat' of a third person in between. Furthermore, it's quite a distance behind the wings, so views should be better.
It's up to your personal assessment whether these benefits outweight the potential drawback of sitting in the rear, e.g. last to deboard, preferred food choice ran out