Spent 1 night there as a family of 4. Beautiful old coaching inn in the centre of picturesque Salisbury, within easy walking distance of everything.
Very clean rooms, good quality fittings and comfortable beds. Very friendly and helpful staff though they did seem a bit rushed off their feet. We were there on a Friday night and there was a bit of street noise, which didn't bother us at all, but if you are a light sleeper you might like to request an interior room.
The reason I took 1 star off was the food, which whilst perfectly good and tasty, seemed a little lacking in inspiration as other reviewers have pointed out. The breakfast buffet had plenty of variety except that there was only one kind of egg (scrambled) which ran out while I was there and was not immediately replaced. They charge extra for hot chocolate, which surprised me - most hotels offer hot chocolate at breakfast and indeed the Red Lion itself had hot chocolate sachets in the room, so makes no sense to me to charge for it at breakfast.
So all in all a good solid option, a friendly and beautiful place to stay.