The S3 is a prosumer camera, its somewhere in between SLR and Point and click. It gives you all the options of an SLR without the lense switching ability.
You can adjust shutter speed and aperture like an SLR, so yes, you'll be able to get pics like that.
You may also want to look into the Canon G7. Those are an excellent line of prosumer camera's.