Yep that's correct the sam specification says that 'S' can only be found ate the ends of reads

To the best of my knowledge you are right. You will never see them in the middle of the read. They should be present either at the start or the end or both. RNAseq (splice aware) aligners use "N" as a cigar character to show the distance between the split parts of the same read.