Symanted makes a couple of inexpensive (a few hundred $) firewall appliances designed for small businesses. There are probably competitors with similar devices. As ANNA noted, since they're designed for a single function they should be more securethan a multi-function device and certainly more secure than a software solution. A software solution can be thwarted by attacking the OS it runs on in addition to the firewall software itself.
Having a firewall (of any sort) isn't enough. You need to properly configure it, apply patches and updates, analyse audit logs and such.
A current best practice is to setup a "defense in depth". The DSL router's internal firewall being the first layer, a 'real' firewall the second and possibly using Win-2k's IPSEC as a third. Each of these barriers is constructed differently and would require a different attack. You can't completely eliminate the possibility of a breach. With care, you can delay an attacker long enough to detect and counter the attack.
Selecting the "enable firewall" check box on your DSL router and running with the default settings provides some protection but default settings tend to become well known and are much easier to defeat than a tailored, multi-level solution.
If the business data or continuity of operations are worth $500 I would spring for the hardware firewall too and establish a second barrier.