Nope. The vast majority require no activation with GFWL. They did start doing that toward the end, Dead Rising 2 was the first, Bulletstorm and Fable 3 were a couple others, but the vast majority had some other form of DRM and GFWL was only an optional application for online features.
I forgot about the decline in games using GfWL. :) The change was about half-way through GfWL's lifespan but by then there were fewer publishers using GfWL, so overall most GfWL games would indeed be of the old type.
This also means that access failures in the future will be the fault of the publishers more often than Microsoft, especially if Microsoft keeps the basic activation functionality online indefinitely after shutting down all other components.
No, that is THE definition of DRM. Digital. Rights. Management.
DRM is about controlling your access to the copy or copies you already
have (copy protection, online activation, offline DRM driver incompatible with new OS, etc.)
I have SimCity 2000 on CD. It's DRM free (no disc check or even a product key). If I lose that CD and don't have other copies I can't (legally) reinstall the game, but I'm not going to blame Maxis. Similarly, if I lose a CD containing the GOG version of SimCity 2000 and GOG has somehow shut down by then I don't see how I can blame GOG just because my CD copy originated from an online source rather than a physical retailer.
Yes, the publisher/distributor carries the blame if they intentionally included a barrier (online or offline) to control access to an existing copy, but I don't think that's on the same level as a digital download server being shut down that has no effect on the functionality of any existing copies (whether already installed or in the original installer form).