Many libraries or library systems actually have something like this. In the Bay Area, the large Santa Clara Library does and at least had regular drop-in hours.

My local library can do vhs and all the various smaller form tapes that came in between like mini dv. They also support cassette tapes and the various consumer projectors people used back when home movies were just becoming a thing. They even have a large bed scanner you can fill with photos and the software will turn them into individual files.