Like the OP, I had always wanted to fly in the front row of a 747. I did get my chance recently on a KLM 747 and found the view to be great - a little forward looking and lots of space. It's not like the cockpit but I think it was the best seat in the house.