Hi MoTheSeeker - Microsoft Lists is an evolution on SharePoint lists (you can learn more here from the SharePoint perspective). Dataflex is a continuation of CDS with an improved app building experience in Teams; more here on Dataflex & Power Virtual Agents.
When you create a new list, you choose to create a personal list which stores the list in your personal Microsoft 365 storage (like files for OneDrive) and to create a new list in an existing team site (whether it's connected to Teams or not). A new list doesn't trigger the creation of a new site, you either create it from within the site, or from the Lists app in Microsoft 365, you choose which site/team to create it in.
Thanks, Mark Kashman (MS Lists PMM)