Aoe2 always has the same response to your type of question: It depends.
Its most likely not worth it against e.g. ethiopians (why make champs vs archers if you have better options) while its most likely worth it against e.g. goth (if you dont go for hand cannons).
So: it depends.