Yes, that is pretty typical AFAIK.
Two issues here, high speed sync (HSS for Canon, Auto FP for Nikon). This mode is for allowing the use of flash at higher shutter speeds by pulsing the flash. At fast shutter speeds, the shutter is never fully open, so the flash has to illuminate different parts of the image, one by one.
Rear curtain (2nd curtain) sync is telling the flash to fire at the end of the exposure, rather than the standard, which is at the start of the exposure. This is mutually exclusive of HSS for obvious reasons.
In 'normal' shooting, you probably wouldn't see a difference between first or second curtain sync. But if you have a longer shutter speed, enough ambient light and some movement of camera or subject, then you will have some motion blur (exposed via ambient light). So for example, someone dancing at a wedding reception and you're dragging the shutter to get some ambient exposure. The flash will still freeze the subject, but if you have enough ambient exposure, you will also get motion blur (actually two separate exposures). If you use first curtain sync, the flash frozen subject is at the start of the exposure and the blur will show in the direction of motion...so if your subject is walking/dancing, the blur looks to be going ahead of them...which tends to look silly or just wrong.
If you use 2nd curtain sync, the flash fires at the end of the exposure, so the ambient blur is behind them, this looks more natural and tends to give the impression of the 'forward' movement.
Note that if you are using TTL metering with 2nd curtain sync, the preflash will still fire before the exposure and so the delay between preflash and actual flash, will be as long as the exposure (in first curtain, it's practically immediate). So there is a possibility of confusing your subjects, especially with longer shutter speeds. They will see the preflash and assume that the photo has been taken and move/look away etc.