Correct, you will need an nVIDIA card to use the CUDA programming model!
I'm considering a Mac Pro to program in OpenCL (less mature than CUDA at the moment, but maturing quickly and will likely overtake it in the long run).
OpenCL can be run on nVIDIA, ATI, AMD, Intel and other hardware. It may not be the best choice now, but be aware of it for the future.