We stayed at this Red Roof Inn this past week for a trip to the Lake George area. Prices were VERY affordable, especially with the AAA rate. The location is nice, given that it's right on Route 9 and access to and from Lake George and the highway is relatively easy. The room had the essentials and not much else, although nothing was really lacking. The front desk staff were all very helpful and the check-in and check-out process were very user friendly.
All in all, as long as you're okay with not having the extra frills of a more expensive hotel, this is a very good place to stay for a Lake George vacation.