Any USB UVC certified camera should work with Mac OS X 10.4.9 (Note that it ONLY works with 4.9, not 4.8 or anything earlier)
Those kind of cameras run about $60 and up from people such as Creative and Logitech.
But yes, I agree that the discontinued iSight blows.