The patch removes the built in SecuROM DRM from the Witcher 2, but any DRM that the distributor uses will still be there, which almost every digital distributor has. For example the steam version will still require the Steam client.
I'm not sure what Gamersgate uses for DRM, so I can't really comment on that. I believe it uses the same method as D2D, where you need online authentication built into the installer to install your download, after which it has none.