We were there this past May for 2 nights before our cruise. We stayed at the Bauer Palazzo. Took a water taxi from the airport, it took us straight to the door of the hotel...no dragging luggage across cobblestone streets!, Great location, just a few minutes from St Mark's square. Very quiet, elevator, breakfast included, beautiful patio overlooking the Grand Canal. We actually saw the Riviera coming in!.
We usually book mid-ship, somewhere close to the elevators. We have never really felt anything, unless we happen to be in really bad water. Also, we were pleasantly surprised to find that it wasn't noisy, like I feared, from people getting on/off the elevator.