"Instead of creating Access databases on a file share, people use SP "lists" to store data"

This seems like a better situation than with Access though; at least the Sharepoint list apps are all located within one system; not as discrete files that may be scattered across laptops, desktops, email accounts and server shares, with who knows how many versions.