In NYC I lived in Brooklyn and took the subway to work and was pretty happy with that. In silicon valley this is usually not an option. There are company shuttles, but it is not the same as just jumping on the next city bound train.
You will need a car, and you will want to live in expensive areas to avoid horrible commutes. This is also true for SF, the transportation system even there is nothing like NYC, even including NJ.
On a personal level, I find SF/Bay area much more boring than NYC. The food options are nowhere near as good either. I'm happy with that as I'm getting older with a nice house and family. But if I was 25 I would stay in NYC, there are more than enough tech jobs there and you can live for cheaper if you want.