The City Nerd channel on YouTube and Nebula discusses this issue a LOT. Trains are by far the most cost effective method of transporting large numbers of people and goods.

Here’s a video discussing costs of car use

Here’s one on the cities with the most affordable housing and transportation costs. As he explains housing and transportation costs are directly linked to each other.