Hi GF,
Don't know from personal experience, but folks I know have suggested that the front window seats in the 747's nose give some really good views (they're sort of a bit forward-ish facing).
If you're on a night flight and want some sleep, upstairs can be quieter, though.
-- Henry