Generally for AT&T DSL, it's always better to go with their "single computer self install package" which includes a DSL modem with built-in NAT router that's limited to a single DHCP lease on the inside interface. The version they're using now is a Westel that's pretty decent when configured to simply be a modem with no NAT services. The 2wire routers provided with the AT&T DSL service are not very good at all and I'd advise staying away from them.
For the AT&T Uverse, however, you are pretty much stuck with the 2Wire 3800HGV-B. It is, however, a much more powerful router than the 2wires provided for the standard DSL service.
That being said, if I were to have AT&T DSL again, I'd get a Cisco 1721 with an ADSL WIC. It's about $100 total on eBay, but is much better than anything you'll find in the SOHO market.