There is a middle ground. Photographs of the objects themselves is almost always allowed. What is not great is trying to get a turn in a popular museum to view a particular piece, but you can't get a clear look because some people need to get a perfect pose for the gram. A lot of these museums in Greece that do this do not lack for visitors; it's often the opposite.