I stayed at the Waterfront Hotel while in Oakland on business. The hotel is a decent value for the money. My room was plenty big - spacious even. The hotel is older, but in good shape; the only thing I saw that needed replacement/upgrading was the hallway carpeting. The motif takes a bit of getting used to...the hotel is on the water so they've gone with a seafaring look. It was clean and tasteful (within the motif), but seemed a bit out of date in 2013.
My room was clean, comfortable and functional. The wireless internet access worked well and there was plenty of space in the room to work. Lighting was good with a variety of options. Windows were large and opened if fresh air is desired. The sink area (outside of bathroom) was large, well-lit and modern; hair-dryer is provided. Plenty of closet and drawer space.
There currently is no restaurant - under renovation/new management and slated to re-open early Feb. 2013; there is limited room service while the restaurant is closed, but there are plenty of restaurant choices within walking distance. There is also a basic continental breakfast available.
The staff and service were outstanding. Special acknowledgement to Aki the concierge and Katrina at the front desk.
Several reviewers have commented on the noise, especially the trains and in some cases the A/C in the room. My A/C worked fine; kept the room comfortable and was not noisy. My room faced the side where the trains go by (1 block away). I did not find the noise excessive and by and large, the trains only run during the day/early evening.
The hotel is right on Jack London Square and convenient to most of the sights, activities and restaurants in that area of town. The convention center is an easy 10-block walk; the hotel also has a shuttle that operates during the day.
All in all, my stay was very good. It was convenient, comfortable and clean. I would stay there again.