The endoplasmic reticulum (ER) plays a fundamental role in maintaining cellular homeostasis by ensuring proper protein folding, lipid metabolism, and calcium regulation. However, disruptions to ER function, known as ER stress, activate the unfolded protein response (UPR) to restore balance. Chronic or unresolved ER stress contributes to metabolic dysfunctions, including insulin resistance, non-alcoholic fatty liver disease (NAFLD), and neurodegenerative disorders such as Parkinson's disease and Alzheimer's disease. Recent studies have also highlighted the importance of mitochondria-ER contact sites (MERCs) and ER-associated inflammation in disease progression. This review explores the current pharmacological landscape targeting ER stress, focusing on therapeutic strategies for rare metabolic and neurodegenerative diseases. It examines small molecules such as tauroursodeoxycholic acid (TUDCA) and 4-phenylbutyric acid (4-PBA), repurposed drugs like 17-AAG (17-N-allylamino-17demethoxygeldanamycin (tanespimycin)) and berberine, and phytochemicals such as resveratrol and hesperidin. Additionally, it discusses emerging therapeutic areas, including soluble epoxide hydrolase (sEH) inhibitors for metabolic disorders and MERCs modulation for neurological diseases. The review emphasizes challenges in translating these therapies to clinical applications, such as toxicity, off-target effects, limited bioavailability, and the lack of large-scale randomized controlled trials (RCTs). It also highlights the potential of personalized medicine approaches and pharmacogenomics in optimizing ER stress-targeting therapies.