It's really worth doing, I had been wanting to do this for a long time, you can read about my course experience here
http://www.egyptianliving.com/showthread.php?t=22
Most resorts are geared up for people coming on a week's holiday and doing the PADI course during their stay.