Globular cluster systems in nearby dwarf galaxies - II. Nuclear star clusters and their relation to massive Galactic globular clusters