As you said, SSIS can't provide the documentation you need out of the box.

You can check out BI documentor, but I haven't found real evidence on their site that it also can do mappings.

You can generate mappings with the ILM models in Powerdesigner, but it isn't the easiest tool to work with.