I like the way GTA IV (PC version) did it. I can download an update if I want, if not I can still play (not sure about online mode though). If it would update itself automatically I would need to wait more than an hour to play it.

So I do not need the game running to download an update. It just links to the rockstar update website - that is the best way for me.