It's a busy City, so best avoided if you are just looking for an overnight stop. Minimum 3 nights needed to see just a few of the sights.
Last time we visited, we used the Crowne Plaza - OK, but not ideal, as we couldn't get into our first choice, the Le Meridian, which overlooks the Aussenalster.