I'm guessing it's just for hobbyists -- "just for the fun of it" kind of thing?
I personally use an WRT54GL hardware to offer public internet access to folks at a coffeeshop. Here is what this $69 USD (when i bought it) device helped with.
Public Wireless - The range covers the entire store and the outdoor seating area. Here we mention terms of service and "beg" them to buy something with captive portal software. I'm not really sure how many clients it can handle, but it certainly meets the need.
Public Terminals - It serves up PXE boot images to 3 netbooted terminals. They run the Linux Terminal Server Project software.
It also makes it easy to set up firewalls, QOS, and anything else you might do with any other Linux box.
I think it's a great deal for $69 USD. This same device has been running for > 4 years!
DD-WRT (and Tomato) were very, very good solutions to this. Still are - there are still a number of popular routers out there where the stock firmware will choke on BT.
I have also set up a bunch of internal static ips for different machines and printers and such, and I seem to recall there was some ridiculously low number of slots to add them in default firmware on one of the routers I was using. (it has been a few years though).
What I'm using: printserver (it has USB port, that is great for sticking printer in) and persistent VPN. It is definitely not just for the fun of it.
I'm pretty sure you can install a web browser and serve up static content from a consumer NAS too.
Basically, it lets you do a large subset of what you would be able to do with an always-on computer, but without burning all that power.
Also, my biggest reason for custom firmware: upping the radio range. Linksys' default output is very conservative.
The ones that came after switched to vxWorks and really slimmed down on the ram.
Then, then introduced the wrt54GL (the L meaning Linux)
It's an easy upgrade for a technical person. Download custom firmware, upload to router, reboot. The same people who would upgrade their own firmware from Linksys can install dd-wrt, Tomato, hyperwrt, etc. Admittedly, that's a small slice of the population but a large number of people.