Even if a house costs $2M in SF, you can earn that in a few years on an engineer's salary.
If you pick the right companies, and are relatively successful, it should be possible to accrue millions of dollars in SV, even with the costs of living. That's rich in my books.
But really rich? There are of founders of tech companies who earn $100M or more from a successful startup. SF is probably one of the most likely place to make that happen.