With two cavernous cathedrals, artworks by native son Goya, and one of Spain’s largest Semana Santa celebrations, Spain’s fifth city demands closer scrutiny, says Paul Stafford