For consumer bridges, DD-WRT probably gives about the greatest flexibility. Some popular Buffalo routers do support WDS-type bridging out of the box, but only officially among specified devices (i.e. other Buffalo products) and they do not support client mode bridging without something like DD-WRT.
Buffalo's "Wireless Ethernet Converter" supports client mode bridging out of the box, and maybe a bit more, but it's not as flexible. Products like these can be good choices if that's all that you're looking for, and want it risk-free (no complicated third-party firmware installation) with vendor support. Check the details if you're interested in this device -- it might even take DD-WRT, which gives you a further "out" if you find that the built-in feature set is not enough. Of course, this doesn't have a WAN port, so it's never going to be entirely as flexible as a router + DD-WRT.
Moreover, reduced demand can raise the prices of dedicated AP/bridges, making something like a Buffalo WHR-G54S or Linksys WRT54GL with DD-WRT the cheapest options.