A personal favourite of three commentaries on Ecclesiastes that I was able to read through and consult. The other two are the Ecclesiastes commentary in the 1) NICOT series by Tremper Longman III and 2) Anchor Yale series by Choon-Leong Seow (Singaporean! Also best cover design I gotta give to it).
Longman is evangelical but leans critical in scholarship. The positive of the NICOT series is that it is quite succinct in its verse-by-verse layout, so it was easy to look out for a specific verse. But Longman's critical-leaning explanations, coupled with how loosely apart the verses are presented, make Ecclesiastes feel like a scrambled piece of work, with Qohelet being a confused, schizophrenia sage, all to have his conclusion upended by the frame-narrator. It was hard to find Longman's critical lens to read Qohelet convincing, or even cohesive at all, as one must question why the frame-narrator goes through so much trouble to present Qohelet's "wisdom" just to criticize it at the end (also O. Palmer Robertson's take on Longman's reading). On the other hand, Seow's commentary stands out on how detailed he is with the exegesis of the original language while being able to spot really subtle literary structures throughout the book that really helps with grasping the difficult texts. Therefore in some places, Seow actually sounded more "conservative" than Longman as he makes more sense of the text, as compared to Longman's "schizophrenia" Qohelet. However, the detail that Seow goes into with the observations on each verse might be quite laborious to read through. Did not read through Seow entirely so was unable to tell from this commentary where he leans theologically, but his association with Princeton and Vanderbilt might suggest that he belongs to the mainline tradition (pinch of salt please).
So how does Bartholomew's commentary stands out from the other two? He is similar to Longman in terms of succinct explanation, therefore not laborious like Seow and therefore beats Seow in being more readable. At the same time, being the most recently written out of the three, Bartholomew employs the subtle literary structures that Seow spots in his commentary (whenever helpful for exegesis), and therefore reads Qohelet in a much better light (less critical) and much better sense than Longman. The most salient and helpful reminder is that Bartholomew consistently situates Qohelet as a teacher in the wisdom tradition of Israel, therefore, a lot of his reading makes a lot of theological sense when read in light of other wisdom books (Proverbs), the Torah (Genesis), and the socioreligio-worship of Israel. Here truly must be the right lens to interpret Ecclesiastes as part of the canon (cues Brevard Child), if we rightly hold to Ecclesiastes as part of the inspired canon given by God: to situate it as part of the wisdom tradition of Israel, consistent with the Torah and temple worship of God.
Besides that, another highlight is how Bartholomew closes the exegesis of each pericope with an in-depth synthesis and analysis section of "theological implications." Here it really shows Bartholomew as a scholar/theologian in the Dutch Neo-Calvinist/Kuyperion tradition. While bringing out the theological motif behind Qohelet's existential quest, Bartholomew borrows and synthesizes the work of scholars from other fields (philosophy, psychology, sociology) and theologians not working directly with Ecclesiastes to enhance and strengthen, contextualize, make concrete and drive home the observations of Qohelet. Works from figures like Jacques Derrida, Wendell Berry, Carl Jung, Oliver O'Donovan, and Eugene Peterson feature prevalently in these "theological implications" sections, demonstrating that Qohelet is not the only one that stumbles upon these enigmas and joys of life through deep meditation and study (cues Bavinck antithesis and common grace). Hence making it also a reading feast akin to a sort of "intersection of theological-philosophical (et etc.) loci," contrary to modern scholarship's insistence on endless, narrow, and ultimately unhelpful specialization. At the same time, these "theological implications" sections also helpfully contextualize Qohelet's wisdom to our current zeitgeist and social-religious climate, therefore allowing the reader to follow Qohelet's existential quest closely without losing a grip on the tangible application of Qohelet's ancient wisdom to our modern life. Bartholomew also concludes Qohelet's existential quest with a postscript, detailing a fascinating overall conclusion on Ecclesiastes through its intersection and relevance against postmodernism, psychology (Jungian reading), spiritual formation, and preaching.
TLDR, if you would only pick up one commentary to ride with Qohelet, let Bartholomew be your guide.