Pyramidal neurons are predominantly found in the cerebral cortex, especially in layers 3 and 5. They also appear in the hippocampus, particularly in the CA1 and CA3 regions, and in the amygdala. Their extensive presence in these key brain areas underscores their importance in higher-order brain functions.