It should work. The new TZ SOHO is in the same class as the TZ 105/205/100/200 range of products. SonicWALL has a technote detailing how to create a STATIC VPN tunnel for an Amazon VPC (Virtual Private Cloud) on AWS:
(points to a PDF to download, latest release is "D", which mentions the TZ 10x/20x line). It also mentions needing SonicOS 5.8, 5.9, 6.1 or 6.2, of certain sub-revisions, the SOHO will be either 5.9 or a 6.x SonicOS I believe. A new device will allow at least 90 days to download firmware updates.
Because the TZ series doesn't support BGP it will only be a Static IPSec VPN tunnel (must be in Tunnel not Policy mode). In your second link select "Example: Generic Customer Gateway (without BGP)" on the left as that is what you will be configuring to get an overview. Amazon will request some IP info from your side and then provide you with the specifics you will use. Then follow the PDF in the above link which shows how to configure the SonicWALL (see the section under "Configuring Amazon VPC with a Policy-Based VPN").
Others have done this, see:
If you have never configured VPNs before then I would suggest setting up a basic site-to-site VPN (between a SonicWALL and another SonicWALL perhaps) just to become familiar with what needs to be done (preferably in routed tunnel mode). The PDF has many screen shots and should be fairly easy to follow if you have configured a VPN on a SonicWALL before or if you're at least somewhat familiar with SonicWALL management and willing to try.
If you wanted a Dynamic BGP VPC to AWS you would either need a higher end SonicWALL or a different device (a Juniper/NetScreen SSG-5 is low-end but still supports BGP and works with Amazon for example).