The Wii Classic Controller / Classic Controller Pro works with games that explicitly support it. Not all Wii titles do.
The Classic Controller plugs into the Wii Remote's expansion port. A Wii Remote is still required to power it.