I had a comfortable basement en-suite twin room for use as a single room. The bedroom had a comfortable single bed for my use. It had a large washbasin and large mirror in front of it. There was a writing desk with chair. The desk had a lamp, and phone to reception, and above the desk was a flat screen tv with remote. The beds had lights and there was a light for the room. The tiled shower room had a shower cubicle and w.c.
Sufficient towels, toilet rolls, paper tissues, and shower/ hand gel dispensers were provided. The bedroom and hotel entrance could be accessed with an electronic keycard. My only problem was that most days, the hot water from the tap was barely warm
The buffet - style breakfast was more than adequate and cost 10 Euros.
Please note that the reception desk is NOT manned late in the evening or overnight.
Although the hotel in Norderstedt is not strictly-speaking in Hamburg, transport is good with local buses and an affordable U-Bahn (metro/tube - style trains), also S-Bahns, buses and ferries. The Hamburg-Card for various lengths of stay provide access to public transport and give some discounts to, say, museums.
These reasonably-priced cards are obtainable from ticket machines at stations by paying cash or using a payment card.