The unsung capital of Wales is often overlooked en route to the coast or mountains, but with its big-hitter galleries and inventive food scene, Caerdydd deserves to be feted with all the gusto of a male voice choir, says Kerry Walker