This would be like living across the bay in Oakland, but much better. Compared to NYC's subway as a general-purpose transport system, BART's more like a commuter rail line that happens to be underground in downtown San Francisco.
Heck, when the MTA decides to strike (which is occasionally, but less frequently than BART) you can walk to Manhattan from Astoria. Try that from Oakland-to-SOMA.