Having no idea of the OP's housing budget, it's impossible to give very focused recommendations. If money is no object, there are plenty of $3M and up condos located near the ballpark, which would be a 10 minute walk to work for his wife and a quick 25-minute drive to the SFO employee lot. Or a nice house in the San Mateo hills for about the same price, a very short drive to SFO and a reasonable CalTrain ride to downtown.

But given the absolute chaos that traffic into and out of downtown SF is, especially Tuesday -Thursdays, plus the $40/day parking cost and the inevitable downtown $15/day congestion fee that the Board of Supervisors keeps talking about... driving into the city for work has become even more ridiculous than ever. I spent years driving into SF every day for work and it was always tough, but now it's just lunacy. BART definitely has its issues but I wouldn't wish a frequent driving commute into downtown SF on anyone. The other day it took me 45 minutes to go the three blocks from the ballpark just to get on 101.

But yeah, if money was no object and convenience was the priority, I'd either get a condo near the ballpark or a house in the hills above SFO. Assuming that the OP doesn't have north of $3M to buy a decent property, I would recommend choosing anywhere that doesn't require a driving commute into SF.