Isn't the stereotypical midlife crisis the Dad whose kids have all moved out? I don't think that has anything to do with modernity or secularity, it's more to do with a large change that triggers a revaluation of your life. That could happen to anyone.
I think that too is a modern and secular thing. If you got 5 kids there's a good chance the older one has made you a grandfather while the younger ones are still at home. So you sort of transition from meaning to meaning
That's the stereotypical midlife crisis "what" for sure. I was more talking about the "who". My point was I don't think it's limited to the secular modern person.