As far as the macro issue goes, I agree. There used to be sites out there that differentiated macros from drafting, admin, part design, surfacing, sheetmetal etc.
The solution to that question is that it should be in the software out-of-the-box. But it isn't because most companies using CATIA let their PLM system generate the titleblocks and frames.