Generally speaking CAF sucked. But buried away in there there were a lot of older, pre-mocapped animations for finshers that looked so much better than the default versions in the game. With CAF, you could make the Rock Bottom from earlier games. You could make a Stuner without your opponent selling it like The Rock. You could make a much more impactful Last Ride.
Basically, CAF was really good for making moves that were taken out, even if you had to use them as finishers or signature moves and had to add a shitty taunt or strike before hand. The corner finisher was also fun if you wanted to make the Malenko super gut buster, Pepsi Plunge, or get on some Zangief shit.