Well, if you want to manage static content on your website, file-storage probably won't help you without some extra work -- as you've evidently noticed. The file-storage module is really for collaborating around documents, not the development of websites. Sorry.
I do know that aD at some point had a file manager integrated with CVS for version 3.3 (but not released). It allowed our graphic designers (at iluvcamp) to update templates without having to go through a programmer. I haven't ever seen this in the wild, so it probably doesn't help you much. However, some benevolent aDer might see this and speak up.
Other Options:
- Use Karl's old standalone CMS (not sure if this works on postgres -- I know the template part does).
- Use Fulfly's port of Ybos' CMS.
- Wait for OpenACS4 - full blown CMS as well as "File Manager" which sounds like the descendent of the versioning upload app I mentioned.
You wouldn't want any advice from me on which one to pick, because I haven't used any of them.