New York Gov. Andrew Cuomo has created controversy after saying America "was never that great," in a speech blasting Republican President Donald Trump.