(Incidentally for those unaware the original poster has been banned.)
I find the relationship between metaphysics and religion frustrating. On the one hand, as you note, religion is intended to "account for the foundational basis of being itself," which is exactly what metaphysics does. On the other hand, the existence of any particular god understood as a literal being rather than metaphorically is a matter of fact. — T Clark
I think I'm starting to get some perspective here. I've been following a very good, scholarly writer who publishes on Medium
Castalian Stream, specialising in stoic philosophers through the perspective of Pierre and Isletraut Hadot. Pierre Hadot is famous for his revival of the values of ancient philosophy, through his books such as Philosophy as a Way of Life, and What is Ancient Philosophy, among others. (More details below if required.)
RevealAccording to Hadot, twentieth- and twenty-first-century academic philosophy has largely lost sight of its ancient origin in a set of spiritual practices that range from forms of dialogue, via species of meditative reflection, to theoretical contemplation. These philosophical practices, as well as the philosophical discourses the different ancient schools developed in conjunction with them, aimed primarily to form, rather than only to inform, the philosophical student. The goal of the ancient philosophies, Hadot argued, was to cultivate a specific, constant attitude toward existence, by way of the rational comprehension of the nature of humanity and its place in the cosmos. ....
According to Hadot’s position as developed in What is Ancient Philosophy?, philosophical discourse must in particular be situated within a wider conception of philosophy that sees philosophy as necessarily involving a kind of existential choice or commitment to a specific way of living one’s entire life. According to Hadot, one became an ancient Platonist, Aristotelian, or Stoic in a manner more comparable to the twenty-first century understanding of religious conversion, rather than the way an undergraduate or graduate student chooses to accept and promote, for example, the theoretical perspectives of Nietzsche, Badiou, Davidson, or Quine.
....Hadot acknowledges his use of the term “spiritual exercises” may create anxieties, by associating philosophical practices more closely with religious devotion than typically done. Hadot’s use of the adjective “spiritual” (or sometimes “existential”) indeed aims to capture how these practices, like devotional practices in the religious traditions, are aimed at generating and reactivating a constant way of living and perceiving in prokopta, despite the distractions, temptations, and difficulties of life. For this reason, they call upon far more than “reason alone.” They also utilize rhetoric and imagination in order “to formulate the rule of life to ourselves in the most striking and concrete way” and aim to actively re-habituate bodily passions, impulses, and desires (as for instance, in Cynic or Stoic practices, abstinence is used to accustom followers to bear cold, heat, hunger, and other privations) — IEP
The point is, ancient stoicism and other philosophies were indeed ways of life, on the basis that to make the 'philosophical ascent' required to attain insight into the 'first principles' required certain characteristics and attributes which the ordinary man (the hoi polloi) lacks. (This is very much the topic of many of the Castalian Stream entries.) It was presumed that those who had such insight were aspiring to be, or actually were, sages (although it was always felt that the true sage was exceptionally rare.) Even stodgy old Aristotle had that side to him.
Reveal
Aristotle never stated this exactly, but in 6.7.2-3 said that Wisdom [σοφία] is the most perfect mode of knowledge. A wise person must have a true conception of unproven first principles and also know the conclusions that follow from them. “Hence Wisdom must be a combination of Intelligence [Intellect; νοῦς] and Scientific Knowledge [ἐπιστήμη]: it must be a consummated knowledge of the most exalted objects.” Contemplation is that activity in which ones nous intuits and delights in first principles.
The point is, us hoi polloi don't see these things, because we're not sufficiently trained. But don't worry! saith Martin Luther. All you need is faith! Who needs all this 'wisdom of the Greeks?' (which is likely to be luciferean, anyway). 'Faith in the Word' is sufficient!
I will grant that is something of a caricature, but I think it's near the point. Interestingly, the one mainstream Western cultural tradition in which Aristotelian metaphysics is still a living culture is the Catholic, and there are Catholic intellectuals who are adept in it (I'm thinking of Jacques Maritain, Edward Feser, Stephen M. Barr, and others of that ilk) because of Aquinas' synthesis of Aristotelian and Neoplatonist philosophy with theology.
In any case, the upshot of a lot of this is that large elements of the consensual metaphysical framework which used to underpin Western culture and society have been forgotten or abandoned, and not really replaced (although there are always nascent forms of a new metaphysic emerging.) But I think this is the deep cultural reason for the uneasiness (not to mention the outright hostility) directed towards metaphysics - too close to religion for comfort!