I am a newbie at camcorders. I am perplexed and confused which one to choose...

I want a sony brand...standard definition only due to budget constraints...I have narrowed down to either DCR-SR220 and DCR-SR47

or

a Sony Cyber-shot DST-T500 or Canon PowerShot SX1 IS (both with HD Movie capabilities)

please help....