I could also see Express edition used for small departmental data marts that aggregate summary data for reporting, something that can be shared between a handful of users.
One of the few nice things I could say about using the Express edition - as opposed to a fully-featured FOSS RDBMS like MySQL - is that it comes bundled with SSRS.