I am originally from the Bay Area, so seldom have an opportunity to stay in hotels in the area. However, my wife and I dropped our son off at my mother's and checked into this hotel. How I could have driven by it for 20 years, and never set foot inside is a mystery (although it was previously a Holiday Inn). We were on the ninth floor with an incomparable view of the Bay Bridge, SF skyline, the bay itself and even part of of the Golden Gate bridge.
The service was pleasant (not fast, mind you, but very pleasant), the room spotless, with a comfortable bed, and the standard Hilton Garden Inn refrigerator and microwave.
There is a Chevy's restaurant next door - so we carried up dinner both nights. There is also a Trader Joe's (among several other shops) just across the freeway for snacks and goodies to take home.
This hotel doesn't really lend itself to public transportation access - but they do offer complimentary shuttle service within a specified radius.
If you go to this area, be sure and walk along the shoreline park.
Finally, the breakfast was nothing to write home about, but it was tasty, and and well presented. The Great American Grill ( the HGI restaurant) has great views of the bay.