Ok, we stayed in a tiny hotel back in 2005, if you have seen Casino Royal it is down that passage way just off St Marks square that the leading woman runs down and James Bond follows. It wasn't anything special but to be honest we only slept there, ate breakfast and came back before evening to freshen up.
It was up on the first floor of a non-descript building past a glass makers. Staff were lovely, breakfast was typical basic buffet, bread, cheese, pates etc there was no view, the bedroom window only opened to let air in and about 5 feet away was another building (very typical in Venice)
But the magic wasn't in the room, it was Venice itself, getting lost (make sure you get a map from the hotel)eating the most amazing food, the high buildings and winding streets, getting around by water bus. Breath taking views and architecture. Ah, very fond memories. I was pregnant, had vile morning sickness and yet nothing could stop that holiday being truly fantastic. We palmed our only child at the time off to both sets of Grandparents, and enjoyed 4 days in Venice, me, DH and a growing tummy (from the baby!!!)
see my poor hotel - google Hotel San Gallo Venice they have their own website (my computer playing up at moment)St Marks is literally 1 minute walk away.