I too am trying to use WordPress as a CMS.
I would love it if, when someone added a comment or modified the post, that it would trickle that post to the top of the site. (ie sort by modified as opposed to creation date)
I found this on the old wordpress wiki, but it is for version 1.2 and I can’t seem to get this to work with the newer 1.5 version of wordpress:
https://wiki.www.ads-software.com/?pagename=HowToChangeSortOrder
There does not appear to be anything in the codex yet on the sort order of posts that I could find either.
Can anyone tell me how to do this?