Text this: Revealing the χeff–q Correlation among Coalescing Binary Black Holes and Tentative Evidence for AGN-driven Hierarchical Mergers