I use my own install of Piwigo and it handles almost 100,000 pictures easily. Modes like "calendar view" by upload OR creation date help to make finding pictures easy, in addition to the ability to tag photos.

I have been pleased with the product and how it works. There are many extensions available to increase the functionality of Piwigo, but I have not tried anything beyond the "core" Piwigo platform.

I have only had a few technical issues (PHP related) over the 6 or 7 years that I have been using it, and my web host was able to resolve those for me.

The biggest downside (and this is why a 4-star rating rather than a 5-star rating) is the lack of detailed product documentation and the unwillingness of the support community to help "newbies". Most times, I can search the support forum for the topic that I have an issue with and can find record of how someone else resolved whatever that issue is. I have never received a helpful response from the forum. Any time I have posted to the forum for help, I get no response or a disrespectful response from that community.

looked for a long time somthing like this!

install script needs to be edited to make it work

Piwigo is a nice and quite efficient image gallery, which has many features. On the negative side, the administration panel is a bit cumbersome, for instance the management of albums requires many clicks which could be avoided with a more effective interface.
However, it's greatest flaw is that it lacks proper security: anyone with the direct URL to the images can access them, even when the album is marked as private. Sadly the Piwigo team doesn't see this as an important security issue and doesn't seem interested in fixing it, claiming the same happens in Facebook (...since when is Facebook a reference for security?).

the hardest part was connecting to mysql & PHP provider.