As far as number theory "paying off": 1) Many proofs in number theory are algorithmic in nature; 2) Computers understand integers with greater facility than they do the psuedo-reals we call floats - often times efficient integer approximations will be more appropriate than slower floating point solutions, and knowing the integers will help you develop/understand these approximations; 3) If cryptography is your bag, number theory is a must; 4) Martin Davis, Yuri Matiyasevich, Julia Robinson, Hilbert's 10th problem, Turing Machines, computability theory, and (the number theory bit) diophantine equations (sorry to be cryptic, this is getting rather long winded).
I have never had to use the theoretical information or complex analysis directly, but the practice gained in studying the theory and the proofs has helped me indirectly many times in programming. For most people. in depth knowledge of mathematics is of limited use, but in depth knowledge of problem solving gained by studying math can be invaluable.
As you mentioned, it varies wildly by your career path of course.
But yeah, I think even none of the things you learn in college end up being useful to you in "real world", it's all about problem solving techniques you master that apply in any situation.