I forgot to circle back on this after our trip.
The short version is that I'd definitely recommend The Pines Resort and will consider staying there again in the future.
We ended up splitting up into two parties. One group had a lake view suite that had a shared deck area with a great view. The other in one of their "chalets" which was quiet and cozy. The chalets are actually duplexes with doors that separate the two units, they'd probably be great for slightly larger groups or families with children.
It seems like summer is definitely the time to be out at the lake. By November, the water level will have dropped significantly. That said, there are plenty of fun trails and scenic overlooks around the lake to enjoy.
Like Brian mentioned, it's a little bit outside of the park but still fairly convenient. Tunnel View and Glacier Point are both conveniently on your way into the valley itself.