There is some guy on Youtube that reviewed his specific generic YMF724-based sound card many many years ago that did have SPDIF on board and he seemed quite fond of it. Though later on, he redacted his initial recommendation due to how hard it is to find a YMF724 card built exactly like his was. So to be honest, it's likely you didn't miss out after all.
Initial review: https://www.youtube.com/watch?v=zueKH6CUVqE
Comment on rescinding his recommendation (w/ timestamp): https://youtu.be/fl3D9trFJ8E?t=1410
Regarding the SPDIF implementation on the Creative AWE-series cards, those SPDIF brackets turned out to be very important due to their proper support for the TTL-level signal, yet back in the day, most users discarded it or lost them in the shuffle, making them exceedingly rare in the long run. If you are out shopping for any AWE32 or AWE64, good luck finding one with the bracket! Frankly, I wish Creative just slapped the coaxial SPDIF port on the card itself rather than on a separate bracket, though I suppose Creative wanted the world to know how they half-assed the implementation anyway. I digress. :)
That ESI Juli@ was the most interesting sound card I ever used, and I've not seen one like it since. I even recall ensuring that it had a dedicated PCI slot for it that did not connect over a PCI-to-PCIe bridge, in case that would introduce latency. Hilariously though, my needs were never particularly stringent. I was just being OCD.
For me? As far as Linux audio subsystems go, I preferred the ease of PulseAudio, even if it was rather buggy in its earlier days. I even played around with JACK many years later, but would go right back to PulseAudio, since it's truly set-it-and-forget-it in the current era... or I guess we default to pipewire now? I kinda stopped paying attention since audio is so seamless now.