I used to do a bit of transportation planning in my salad days.
The short answer is no.
The only system that comes close to covering operating cost is NYC. That is due to the churning of the fare box, many off and on riders, lots of short rides, constant use. All other systems must receive operating subsidies.
All modern systems could only be built with massive federal capital grants.
In addition the energy used in constructing underground systems is never recovered or offset by energy savings through use.
Like almost all things in America, it is a boondoggle to support dying, corrupt, and decayed cities by redistributing money from earners to takers. It is the avowed policies of all democraps and their quisling republicans that this continue.
You and I think alike on these matters.
If a mass transit item can’t pay for itself, it doesn’t need to exist.