The typical direction of tornado rotation in the Northern Hemisphere is cyclonic. Viewed from above, that usually means counterclockwise rotation, matching the circulation of the larger storm system that produces the tornado.
Tornadoes generally develop beneath rotating supercell thunderstorms. Their low-level rotation comes mainly from wind shear and storm dynamics, not directly from Earth’s Coriolis effect; tornadoes are too small and short-lived for Coriolis force to dominate their spin.
The common mix-up is treating “counterclockwise” and “cyclonic” as unrelated answers. In the Northern Hemisphere, cyclonic rotation is counterclockwise, while in the Southern Hemisphere it is clockwise. A small minority of Northern Hemisphere tornadoes rotate anticyclonically, so “always counterclockwise” would be too absolute—but “cyclonic” is the standard answer for the typical case.