We actively use this at Street Art Cities (https://streetartcities.com). Really helped keep hosting costs down for a project that is more community than commercial, and created a more cohesive experience.
Little blog post here: https://schof.co/moving-over-street-art-cities-to-pmtiles-an...