I like the new Override layer visibility option for Map Frames, but I think it's use case is very limited. I would like to be able to make changes to the layer and have those changes only apply to a single map frame. A recent use case I had was I had multiple map frames in a layout, and in some of those frames I wanted to remove the labels, but I still wanted to keep the symbology showing the feature. Another case I would have found this useful is being able to change the SQL Query in separate map frames. That way I could have the same layers in the map, but change what parts of each layer is visible. I could also see it being useful if I could change the symbology of a layer for different map frames.
Generally, I would like to see the Override layer visibility feature be improved to something like "Override layer details" or added features like "Override layer symbology," "Override layer labeling," etc.