FWIW my early 40s were a golden age in my marriage - basically once the kids got old enough to reliably sleep through the night.
edit: Actually "menopause" is being a bit glib. Things change in relationships, and often it's very difficult to understand why.