This paper presents a novel meta-functional auxetic unit (MFAU) cell designed to improve performance and weight ratio for structural bridge bearing applications. Numerical investigations were conducted using three-dimensional finite element models validated by experimental results. The validated models were exposed to compression and buckling actions to identify structural failure modes, with special attention placed on the global behaviours of the meta-functional auxetic (MFA) composite bridge bearing. This bearing uses an unprecedented auxetic sandwich core design consisting of multiple MFAU cells. Numerical predictions of the elastic local critical buckling loads of the MFAU cell were in excellent agreement with both the analytical and experimental results, with an observed discrepancy of less than 1%. These results demonstrate that local buckling failures of MFAU cells can potentially be incurred prior to yielding under compression due to their slenderness ratios. Surprisingly, the designed sandwich core used in the MFA composite bridge bearing model can mimic an auxetic structure with significant crashworthiness, implying that this novel core composite structure can be tailored for structural bridge bearing applications. Parametric studies were thus carried out in order to enrich our insight into the MFA composite elements. These insights, stemming from both experimental and numerical studies, enable a novel design paradigm for MFAU that can significantly enhance the structural performance of MFA composite bridge bearings in practice.