zymran,

1. Security. Does CE support dynamic images/resource/media folders for users e.x. based on their login names or are the XML files for security and roles fix those folders or the roles mentioned (admin, users etc).?

Yes, the CE supports dynamic images/resource/media folders.

 

 Example:

   var  folder = "whatever";
   string phyfolder=Server.MapPath(folder);
   System.IO.Directory.CreateDirectory(phyfolder);

   Editor1.Setting["security:ImageGalleryPath"]=
   Editor1.Setting["security:MediaGalleryPath"]=
   Editor1.Setting["security:FlashGalleryPath"]=
   Editor1.Setting["security:FilesGallaryPath"]=
    folder;

 

2.Binding/updating to databases. Could it be used to bind/update middle-tier objects as well?

 

Yes.