ID did a pretty good job w/ q3.. the whole cd key thing seems to be very effective... for online play.
but yeah, whatever comes out, there will eventually be a way around it most likely. The most difficult things I see right now would be ps2 games that utilized the entire capacity of their discs.