VPN Router Reviews

I am looking for some suggestions on buying an ALL-IN-One Security appliance. I would like this to act as a VPN Gateway for my main office that has a STATIC Public IP. I would like to connect 3 remote office using site to site tunnels using Dynamic Public IP’s on couple of sites. I would also have some VPN Clients connecting from hotel rooms using VPN Software. Also need this to act as a firewall and Internet Filtering appliance. I have looked at sonicwall 2040 and wanted to get some suggestions. For remote offices I was looking at sonicwall TZ170. What do u guys think?
Thanks in advance