I've many dozens "small business" deployments (less then 10 workstations, and few up to 30)
On my main work, we've deployed over a dozen servers as small file/backup servers for smaller workgroups up to 130 users and few bigger boxes as central web and database servers for 1700+ users.
Typical SME use is: firewall/gateway/VPN, file-print server, less mail server and almost always backup server all on the same box.
In the bigger installations I've used it as dedicated mail or/and webserver, dedicated file server and often as domain controller.
Never as a firewall only, but often as a file server only.
Depends on installation purpose I use AV/spam related addons, advanced workgroup addon, dhcp management, chroot ftp, user-panel, awstats, system-monitor, APC-UPS, phpmyadmin, backup2ws, disklow alarm, raidmonitor, if mirror used, twiggi.
From my understanding this is attemtp to collect "real-life to wish-list" set of standrd or most used addons. I would like to see the core distro clean as it is and then add addons as a packs. Let say "WEB server pack" include awstats, chroot ftp, user-shell etc...
"LAN server" pack with advanced workgroup management, DHCP, domain management tools etc...
"ADVANCED MAIL Server pack" AV, spam control, vdomain management, fetchmail or similar etc..
Often used add-ons like system-monitor, disklow alarm, raid-monitor should be part of core distro.
As for if SME Server lived up to the promise, that I only had once have to replace SME with MS Windows server because the main application requirements and I still regret that. So much more problems for the same money