So, I don't know if every CPAN module tar file includes a "META.yml" file,

So do, some don't. The same information is usually in either the Makefile.PL or the Build.PL file. But this will only list the immediate dependencies, and not anything those dependencies depend on.

I think the best bet is to install them while you have the net connection, and save yourself the possible frustration later on.