I can sleep like a baby on 3 across, and have done it on single aisle planes where having the aisle seat effectively precludes anyone from reseating themselves into the window after boarding completed. Trying to do this in the center section of a widebody is difficult for the reasons noted.
But I wouldn't forego the opportunity to upgrade.