Spin-3/2 physics of semiconductor hole nanowires: Valence-band mixing and tunable interplay between bulk-material and orbital bound-state spin splittings