I've been on just about every seat in a 747, and you should look up seat plans on seatguru.com for your specific flight.
However, some points to note:
First of all , the upper deck is not restricted to FFs, it's like any other section, just happens to be mostly J and sometimes F class.
If you fly F, sit all the way up front (1A/K) in the nosecone, it feels really unique. The crunch of the landing gear retracting on take off is also a real treat!
If flying biz class, get upstairs, makes a big difference. If its a 747-200, then its small and clubby.
In Economy, its not as bad as it sounds. There are plenty of odd seats with a lot of space around them, even far back (51-53 on BA
). For a truly 'first class' experience, 3 or 4 empty seats across can't be beat.
If you love flying, I would go for any window seat, and enjoy the view outside. However, I've also flown in the middle seat on a 10-hour flight, and it's not as bad as it sounds.
Some other tips - AI
has a combi flight where you can sit up front in economy. Some airlines may still have economy on the upper deck.
There is something to be said for sitting in the noisiest part of the plane, and enjoying all the grunts and groans of the magnificent beast that the 747 is!