For your budget, Casio EZ-55, Ricoh Capllo R-1 (4M only), Canon Digital IXUS 500 & Canon A95 (if for normal photo shots) seems pretty good deals. The 1st two use SD and the Canons use CF type I.
(but don't count on their video quality!)
If you want a little bit better, try Canon S60 (US$50-100 more), more to be a "prosumer" level.
Sony: I will only recommend W-1 (5M pixels), the amount you pay for the function you get is more realistic. T1, T11 and T3 are not that good, too expenisve without great add-on functions in shooting (relative to W1).
That's why T series become popular very quickly and re-selling rate are also very high in Asia. People treat them as trendy products, like fashions, and replace them for a much better and realistic DC (e.g. Casio, Canon and Panasonic. haha).
I don't really consider HP and Gateway DCs though they are really cheap.
They are not even comparable to those mainstream Japanese DCs. That's why these brands' sale are nothing in Asia, compared to US.
However, all above is my personal opinion coz we are all spoiled by Japanese electronic toys every day. Thus, Canon and Sony would be my only 2 choices in US.
P4 2.8C GHz w/ Intel 865PERL
2*120 GB SATA w/RAID 5
ASUS GeForce 5600FX
NEC-1300A + AOpen 16x DVD
Only order components from HK & Taiwan, US market sucks