Fundamental And Phenomenological Aspects of Anti-D-Brane Supersymmetry Breaking