We stayed at the sunflower hotel as part of a intrepid tour. The hotel itself is in a good position but thats about where the positives end. The front desk staff were very unhelpful and uninterested in our presence. We stayed on the 3rd floor in a room that was dark and very stale. The television did not work and the air-conditioning worked at times. The bed was very hard and on opening a menu in the room it was found to have dirt and what looked like food wiped inside it. The bathroom was again very basic but fine for our needs. In the bathroom there was an open vent, every now and then there would be some very interesting smells come through, none of which were very nice.
It is hard for me to comment on value for money as it was incorporated into the tour cost. After spending some time in Hanoi it was evident that there are much better accommodation options available.