I went with a friend a few years ago and we stayed in the Sequoia Lodge (I think that's what it's called anyway - it was one of the middle-priced ones)
From what I remember the hotel was really nice - two HUGE double beds in each room - very American in style (which is what you'd expect from Disney). Also, it was only a short walk round the lake from the Disney Village and the station so was convenient as well.

Would have liked to stay in the big pink Disneyland hotel but unfortunately we couldn't afford it.