I too dread having to book a B&B and have the forced polite conversations when I just want to be left alone!
I love a quiet, but not totally "dead" hotel. The best I've ever stayed in was in Burnley when I visited my son in nearby Todmorden. It was an old Mill owner's house with lots of original features and a nice little garden and the staff were so good to me (I had a broken wrist and they had to cut up my food for me!), and the room was really quirky and comfy and private. In case anyone wants to try it, it was the Rosehill House hotel - single bedroom en suite photo attached.
I usually go for Premier Inn if I'm in a city, as they're always clean and comfortable and cheap and I can get a cooked breakfast in-house. On the one occasion there that I had a very disturbed night (due to an aggressive drunk banging on everyone's doors and demanding his female friend/wife/whatever came out) I wasn't charged for that night, just as they claim in their promotional material.