I was there in early June 2022. I visited the Zimbabwean side both walking and helicopter.

First thing to know is that the falls vary dramatically depending on the rain. June was right after the end of the rainy season and there was a LOT of water in the falls. There are about 15 view points, numbered from the east (farthest from Zambia) and only the first 4 or 5 were usable to see the magnificent falls. The others were a mix of fog & rain where you can't see much. From the pictures at the entrance of the park, there are much less water in September / October. 

I also took a 15 minutes helicopter tour ($150+10% tax) which focused on the falls, longer tours seem to also fly above the game park to see wildlife. Views from above were surprisingly nice an clear. All the fog is actually on the side opposite of the falls where people walk but not much fog on the side of the falls. The pilot goes around twice: right & left side of the helicopter so all the passengers would enjoy the view.