How to deal with 404's

at a crossroads here, should we allow the cms to render a custom 404 page, and/or deal with the error differently than an active record error?