Achieving enhanced or blue-shifted emission from piezochromic materials remains a major challenge. Covalent organic frameworks (COFs) are promising candidates for the development of piezochromic materials owing to their dynamic structures and adjustable optical properties, where the emission behaviors are not solely determined by the functional groups, but are also greatly influenced by the specific geometric arrangement. Nevertheless, this area remains relatively understudied. In this study, a successful synthesis of a series of bicarbazole-based COFs with varying topologies, dimensions, and linkages was conducted, followed by an investigation of their structural and emission properties under hydrostatic pressure generated by a diamond anvil cell. Consequently, these COFs exhibited distinct piezochromic behaviors, particularly a remarkable pressure-induced emission enhancement (PIEE) phenomenon with a 16-fold increase in fluorescence intensity from three-dimensional COFs, surpassing the performance of CPMs and most organic small molecules with PIEE behavior. On the contrary, three two-dimensional COFs with flexible structures exhibited rare blue-shifted emission, whereas the variants with rigid and conjugated structures showed common red-shifted and reduced emission. Mechanism research further revealed that these different piezochromic behaviors were primarily determined by interlayer distance and interaction.