Hey, anyone had any experience or know of an ADSL/WiFi router which can be installed at a branch office and can:
Be centrally managed through a head office console. Provide local direct internet access over wired and WiFi SSID Provide VPN connection back to head office on different SSID and different wired interface.
What you describe is exactly what the Cisco ISR series are designed for.
800 Series are your baby branch router (up to 25Mbit) 1900 Series are a little bigger (up to 100Mbit) 2900 goes to (200-500Mbit) 3900 goes to Gig+
The 880 series upwards all have the same features so you just scale based on branch size. All models from 880 up can do wireless with lots of SSIDs, VPNs of varying kinds, guest networks etc.
If you have 200 sites, read up on Cisco DMVPN - it would make this easy.
Not to mention all those Cisco's can have support contracts attached ranging from 8x5xNBD to 24x7x2 for hardware replacement and support/updates. Which is important if you want to manage 200 sites without going crazy.
The 1900 and up can also house switch modules so you can get to a single box as you say above.
Management can be done either individually as needed (what I'd suggest) or there are tools for managing them as a whole network.
PM me if you want further help - this is what I spend most of my day doing.