I've tried with my wifes SD600 with OK results, though macro shots were pretty disappointing. On the up side, the 750 does come with an 'Aquarium' shooting mode which I'm guessing will compensate for the higher K light values.
Personally, I would save more money and get a better camera like the Canon PowerShot G7. It can be had for around $450 if you shop around and is far superior to the 750 in many ways yet does not have the complexity of a DSLR.