Ya, you fundamentally cannot do seemless concatenation with Sound Cues. Sound Cues run on the game thread, they’re limited by the time it takes to communicate between the game thread and audio render thread.
You can, however, concatenate sample-accurately in MetaSounds. Syntax looks like of like this: