A new thriller series shot in Scotland makes Glasgow look “pretty spectacular” amid other productions that portray the city as “gritty”, the leading actor has said.