Generally the view from the front of the balcony would be better than from back in the orchestra. However, another good reason to move up there would be comfort.
My wife and I are both somewhat tall, and leg room can be a problem in theatres. At our local community theatre, we won’t sit anywhere in the balcony except for the front row, because those are the only balcony seats that have any leg room at all.
So front of the balcony is usually pretty awesome.