I found archery quite nice. Then I switched to a mage career and shot everything down with fireball and ice lance.

The latest CP is a must IMHO. But of ocurse it's also okay if you don't want to use it.