If you are looking for a mid-range hotel, in the very lively Old Quarter of Hanoi, I think Sunshine 1 Hotel is a good choice. I was there in the winter, with record-breaking colds, so the windows were closed at all times, and the heating system was efficient. If you want less noise from the street, try the rooms in the back. In winter, people go to bed around 11H PM so it was quiet to sleep. The beds are very good, and the room is very clean, I saw no bugs of any kind (again, maybe they were frozen). The bathrooms are a bit outdated, but there was plenty of hot water, there was a bath also, and a hairdryer. There is a flat screen TV with cable. But the best feature of the room is the computer with internet wich you can use as long as you want, it is included in the price. Since I started my trip to Vietnam in Hanoi, it was so useful to organize sidetrips to Halong, Sapa, etc...I really enjoyed the location. The breakfast is in another hotel from the same chain, about 3 doors away, and it was a bit boring. If you get tired of it, you can grab a pho bo anywhere on the street, it is sooo good! As for service, I always had a quick and efficient response when I asked for something. But the personnel was not particularly warm, I think they were shy because I am a women in her 50's travelling alone. Great value hotel, would go back.

We stayed at the Sunshine Hotel for a few days while checking out Nothern Vietnam. The personnel was very helpful when we were off for a few days to Sa Pa and Ha Long Bay and were willing to keep our (very spacious) room available for us. Great service!
Only downside was the somewhat noisy environment, but I guess that u can't expect total silence in downtown Old Quarter Hanoi

We found our room to be very clean and extra large in size.
The position is great.
Staff at the front desk were always helpful and friendly.
The only downside of this hotel is the breakfast which is served at one of the other Sunshine hotels just 20 meters or so down the road. It really was the worst we had in Vietnam and probably worth giving a miss.
As is the case in all of Vietnam, I would recommend you bring earplugs to improve your quality of sleep.

really good location. near the lakes and the markets and the streets are all good and fun.
theres a computer and internet in your room which is great.
the staff were really nice guys. very hospitalble and strong for those stairs and the baggage we travelled with. (theres no lift.)
the room was spacious but not very plush. its kind of like your nanas old guest room.
the window leaked. or maybe it was the fridge.
the bed was kinda a bit hard for me. but you might like that.
there was free fruit.
and it was quiet......