There's the Waterfront Hotel in Jack London Square. Its a nice -- right on the water (Oakland Estuary), has nice views and sounds (seagulls, sailboats, ...), and there's plenty of shops and restaurants right there. Its a few miles from the airport, an easy cab ride, but anything closer to the airport will be kind of dreary and isolated. (Nearby Jack London Inn is not as nice.)
If you need any other Oakland rec's let me know.