In many museums around the world photography is allowed, provided that no flash or tripod is used. I suspect that both restrictions are made for the convenience of other visitors rather than to prevent photographers from taking high-quality photos. I find this totally acceptable, as it would be extremely tedious to catalogue the museum’s collection anyway. Instead, I think it makes sense to capture the experience of visiting the museum, and for this task, modern cameras with their excellent low-light performance are more than adequate.
During my visit to the Sforza castle in Milan, I did not even take my fastest lens, instead, I used Canon’s Canon 24-105mm f/4 L IS USM
I often use my camera in museums purely as a note-taking tool. I take snapshots of the works of art themselves and of the side panels that provide reference information (in the hope that some day, I will actually make time to review these notes and perhaps even make some use of them).
