I have an anecdote about this.
In my somehow big city (1m habitants in France), they wanted to create a train line between my city and another one. As every infrastructure projects in France, the project eventually had years of delay (maybe 3 or 4).
So at the due date, no train line. But the trains (about 20 of them, IIRC) were acquired and stored somewhere.
So we had those trains without rails. Somehow, local politics decided to let them roll temporary on an existing national train line.
Nobody anticipated it, but all cities with a train station on this old line started to gain a ton of attractiveness. The real estate prices and population on those cities raised by 30-40% in 2 to 3 years.
People were just happy to live countryside while being able to move to work without cars. And that’s totally reasonable since with this high numbers of trains, this line is now able to have a 20min frequency.
Eventually, local politics decided to let the trains indefinitely and just buy 20 more for the new line. Which of course, added delay :D
——
I have a great car. But I think any mean of transport is really more pleasant than car. The only problem is they are not always all as optimal as a car. But it’s an infrastructure problem. Public transports without rails is as optimal as your car without a road.