https://www.doesitplay.org

I guess this resource is relevant to the topic at hand. It lists games and whether you can play and complete them fully from disc without an internet connection