I’ve always been partial to seating near the wings for a smoother ride, but was seated in the nose of a 747 once for the novelty. Cool and a little discomfiting. You have a bit of a forward view due to the nose tapering before the windows end. I’ve been upstairs while in flight, but it was a lounge/bar area. A slight bit of rolling sensation, but very cool. Love the 747, pity that the packaging and basic form can’t be carried forward with a more modern craft.
What was odd to me about sitting in the nose, (row 2) was the sensation when taxiing. You are in front of the nose gear and it really messed with my proprioception.
Upstairs I was seated in the front row left (Row 60, Sear A) on a British Airways 747. Upstairs the the A and K seats face the rear. (Actually, downstairs in Business class they do too.) They only had 20 seats up there, so it felt like a private jet.