The Bern Hotel is literally just at the start of the cobbled street area. It is a few minutes walk from the old city gates, the bus station (in the city centre) and trams. We were dropped off by the bus station out of town, but it cost very little money to travel by taxi to the hotel. It was also very cheap to travel by taxi to the airport, it only took us 20 minutes to leave the hotel reception, travel by taxi, go through security and arrive at our departure gate!!!
Having read the other reviews I was worried about the noise from the club next door, but we were staying there in July and it was very quiet at night despite our room overlooking the "club". It is a themed German "ale house" with waitresses dressed up (there is a similar one in the centre of Tallinn). The beer was very expensive and for this reason it was extremely quiet at night. It is certainly not a strip club as some guests have claimed and I nearly didn't book the hotel after reading their comments!
The receptionists were very helpful, speaking excellent English. Please note there are NO public phone boxes anywhere in Estonia, so you need a mobile or pay hotel phone rates. There was only one free computer with internet in the little library/meeting room, and it was extremely slow.
The aircon in the room was welcome as it was over 30 degrees in Tallinn. We would buy picnic ingredients including warm pizza and garlic bread from the supermarket across the road from the hotel. Nice pubs to visit are the Scotland Yard behind the hotel, the Hell Hunt, the Mexican themed restaurant and, of course, the main Ale House with live music and traditional dancing. We also enjoyed watching classical music in the Moroccan themed Master's Courtyard. In several of the restaurants traditional Russian dancers would provide entertainment to diners and passersby.
Tallinn itself is like being in mediaeval land at Alton Towers with a lot of the restaurants, bars and their staff being themed and therefore expensive. We ourselves preferred Riga, but the towers and walls were lovely and some of the views were fabulous. It is certainly not a place for the disabled with cobbled streets and steep climbs. We also visited the nearby beach using the local bus, which was not the best beach I have ever been on and the water was extremely shallow.