We have stayed several times at the Holiday Inn, Sipson Road, West Drayton. There is a shuttle service between the airport and the hotel but you do pay for it. The hotel is nice, everything you need for a night's stay but it is also just on the edge of Sipson village, which while not one of the most picturesque in UK (this is the one they want to tear down for the new runway) does have a few pubs and the one closet to the hotel has good food.
Usually good prices on lastminute.com or the hotel itself.
There are several Holiday Inns near Heathrow but this is the only one I have stayed in.