cod4 has better campaign as said before.
I think it depends really, cod4 is more stealthy, cod5 is more actiony. So it does depend on what you prefer.
I think they're both as good as each other. I'm better at cod5 though, dunno why.