(This is intended for various posters, but certainly not the preceding poster.)

What pikes are supposed to be:
Good at defending, especially against cavalry.

What pikes are not supposed to be:
Good at attacking.
Good at chasing routed cavalry.
Good at soaking up missile fire.
Good at demolishing walls.

As IncubusDragon was saying, use the right tool for the job. If you want a good attacker, use knights (mounted or dismounted, depending on opponent). If you want to chase routed cavalry, use light cavalry. If you want to soak up missile fire, use peasants. If you want to demolish walls, use artillery.

Yes, you can mod pikes to make them good at something they are not supposed to be, but what would be the point? Whilst you're at it, why not give them higher stats, horses, shields and shoulder-mounted culverin? Because they're not supposed to have them, that's why. If they did, no other units would be required.

Use pikes for what they are - a good defence that needs balanced support from other units capable of performing other functions.

Why else do you think pikes have been "bugged" in this way since RTW?