A variety of U.S. Food and Drug Administration-approved hormone therapy options are currently used to successfully alleviate unwanted symptoms associated with the changing endogenous hormonal milieu that occurs in midlife with menopause. Depending on the primary indication for treatment, different hormone therapy formulations are utilized, including estrogen-only, progestogen-only, or combined estrogen plus progestogen options. There is little known about how these formulations, or their unique pharmacodynamics, impact neurobiological processes. Seemingly disparate pre-clinical and clinical findings regarding the cognitive effects of hormone therapies, such as the negative effects associated with conjugated equine estrogens and medroxyprogesterone acetate vs. naturally circulating 17β-estradiol (E2) and progesterone, signal a critical need to further investigate the neuro-cognitive impact of hormone therapy formulations. Here, utilizing a rat model of transitional menopause, we administered either E2, progesterone, levonorgestrel, or combinations of E2 with progesterone or with levonorgestrel daily to follicle-depleted, middle-aged rats. A battery of assessments, including spatial memory, anxiety-like behaviors, and depressive-like behaviors, as well as endocrine status and ovarian follicle complement, were evaluated. Results indicate divergent outcomes for memory, anxiety, and depression, as well as unique physiological profiles, that were dependent upon the hormone regimen administered. Overall, the combination hormone treatments had the most consistently favorable profile for the domains evaluated in rats that had undergone experimentally induced transitional menopause and remained ovary-intact. The collective results underscore the importance of investigating variations in hormone therapy formulation as well as the menopause background upon which these formulations are delivered.