Is the result of a human cell division two offspring nuclei each containing 23 chromosomes?

Broadly speaking, yes. It should be pointed out, however, that mature red blood cells are somatic cells which contain no chromosomes at all. Also, osteoclasts are somatic cells which contain multiple nuclei and thus multiple pairs of homologous chromosomes (although they only have 23 homologous chromosomes in any given nucleus).