Stereotactic biopsy is particularly useful in diagnosing breast cancer, especially when microcalcifications or tiny lumps are detected that are not palpable. It can also be used for brain tumors, lung nodules, and other cancers where precise tissue sampling is crucial for an accurate diagnosis.