yeah it's a mesh vpn setup, it's pretty slick, as long as everything you want is net accessible, it can pretty much be accessed using tailscale. Stable diffusion web interface for example, could be made accessible over the network, though you might need to do a reverse proxy or ssh tunnel or something like that, but it should be possible.

I've been using as a vpn proxy for mobile devices on my server network (or externally), i just have my subnet shared through the primary node, and then other devices can access them directly through tailscale.

ZeroTier is another alternative. Don't really know the differences but if you're googling about tailscale it might be worth a check.