It won't do nearly as much damage as lying on the bottom, but it is still better to be hovering.BTW, I have seen photographers who do something that looks like a fin pivot with their fins planted on the ocean floor and their body hovering waiting for that perfect shot.
So maybe there is a use for it.
When I dived at Puerta Galera in the Philippines, everyone was required to watch a film showing how not to damage the reef while doing photography, and fin pivoting was a no-no. When a big-camera photographer in my group put his fin tips on the reef while he was shooting, the DM came behind him and lifted the fins off the reef.