And please don't forget the IBC/IRC structural codes, as we notch, bore and otherwise weaken structural members that the structural engineer would rather not be cut at all... In fact, we may want to politely remind our plumbing colleagues of the same, before they center-bore a structural 2x6 to fit 3" PVC pipe...
As for me, I have to not only contend with ICC and NEC, but a minefield of federal requirements and foreign codes. I don't care how experienced you are, it's impossible for one person to know them all. I run across new codes and requirements I'm bound to practically every time I crack a new reference. I'd say 99% of the time, we're in compliance even without knowing the requirement, just because it's good practice. (Also, it helps that the NEC is typically far more restrictive than any foreign codes.) But those handful of times, it can get to be a real pain in the ass...