Ashton,
My recommendation is the SSY1. The YAG laser gives you much more in the way of options for upgrading and tinkering (adding KTP, holography, adding larger flashtubes, adding diode pumping, building custom resonators, changing or removing q-switches, etc). The CO2 system is fixed since the tube is sealed. You can't really add more power without burning the tube. In the end, however, having both is the best of both worlds.
As far as the most powerful commercially available system for a consumer, it's only limited by the system meeting FDA requirements for safety systems. If the system contains the 5 required safety systems any consumer can purchase it. You can buy CO2 systems in the thousands of watts CW and pulsed systems in the hundreds of Joules if you have the cash.