That is precisely what Microsoft intends with MOSS 2007 Content Management. Using Document Libraries, Picture Libraries, Form libraries, and Wiki page libraries combined (or not) with Workflow (several types available).
Microsoft is wanting to veer away from the traditional 'mapped drive' and...