I live in the northeast USA, there are very few public collecting spots around me. It makes me really sad listening to people who have been in the hobby for a long time talk about all the amazing collecting sites they used to frequent before they were paved over with parking lots or condominiums and whatnot. There isn't a whole lot of "wild open space" left around here to poke about in. Another big factor for keeping the public out of collecting sites that do still exist is that some people can't be bothered to be respectful in their collecting.
The Loudville lead mine in Easthampton MA, which used to be open for public collecting, recently closed due to irresponsible collecting and severe erosion. They closed off the entire recreational trail system, which has far reaching affects far beyond the rockhounding community.
I'd collected once at Loudville shortly before it closed and found a couple scraps of Pyromorphite, some tiny Wulfenite you need a microscope to see, and some Malachite. I am sad that I can't go back, now.
You can read more about it here: https://newenglandforestry.org/newsroom/recreation-on-the-ro...
I don't expect, or really even want to find museum-quality specimens, I just want the ability to explore the minerology of my home region on a physical and personal level.