Check out the Wiki package, as it makes use of the CR TCL API.
My rule of thumb for when to use acs_objects, is to use acs_objects when I need to use the permissions API for accessing info in a particular table.
I don't use acs_objects for tables that simply map one ID with another ID.
In most cases I tend to use acs_objects.
