I thought it was pretty good - but nowhere near ideal of course.
But discovered I could dispense with both of Apple's "Light Seal Cushions" and simply line the light seal with some 1/8 adhesive foam. It took a little experimenting to avoid hard pressure points, and then make it comfortable.
It is now very comfortable with the following benefits:
1. The field of view is noticeably wider. Yay! The immersion improvement feels cognitively significant.
2. I realized that greater peripheral vision downward is more important than upward. Being more aware of down makes us feel safer and is also where are our hands and keyboards live.
So I arranged the padding to wear the head set slightly lower, allocating all the increased vertical FOV downward.
3. The combination of being 1/4 inch or so closer to the face, and firmer padding, reduced the feeling of weight on the front of my head.
Warning - literally. I get an occasional popup warning that my eyes are too close to the lenses. The danger being if I were to fall I could potentially hit my eyes. I stay seated most the time, but occasionally walk through rooms, so it is worth being careful.
I use my Vision Pro for 10 hours a day on many days, comfortably. I had to switch to the two-strap support to do this. But I have ordered an adapter that allows the original behind the heat cushion strap to be used with a second cushion strap over the head. I anticipate that working even better, given how much surface area weight will be distributed across. (Also turning a knob is easier for adjustments than messing with velcro.)
Also, got some thicker (in width) lighter foam, to add some more light seal around the edges.
This feels like a real upgrade, a year or so before Apple will release a bump.