I have read that some certain types of cancer are nearly always fatal, but what about brain cancer in general?

Yes. Usually brain tumors are metastatic coming from other organs cancer and these are usually not curable diseases. Some primary brain cancers can be very aggressive and fatal and some of them are slow-growing tumors and their course can be more indolent.