Can there be a type of brain surgery that is used only as a last resort?

Yes. Many types of brain surgery are done only as as last resort. For instance, hemi-craniectomy (removal of half the skull) for brain trauma is done as a last resort surgery. Also, hemispherectomies (removal of half the brain) is usually done as a last resort for severe seizure disorder in children.