A critical assessment of the Self-Interaction Corrected Local Density Functional method and its algorithmic implementation