I live in St. Leo's neighborhood (Cleaves and Park) which is a ten-minute walk to the Sharktank, er SAP Center. As a resident, I think the proximity to SAP, downtown, the train station and light rail makes for better quality of life. We do have street parking by permit only so SA Center goers don't clog up our residential streets. Most of my neighbors agree.
However, people are divided on the benefit of the proposed major league baseball stadium (equally nearby). I personally love the idea.
Best, Marc, San Jose