Are there any solutions for dealing with xfinity hotspots which are in range to join, but may not have internet access?

I'd like to leverage the open access (as a Comcast subscriber), but I stopped auto joining the networks as sometimes with 2-3 bars of signal, there is no internet.

I already have a Pi connected to 5G phone and it would be great to be able to utilitize the hotspot as well.