So I put some time aside to experiment a bit before calling Sonos. The idea, as you suggested, was to create a copy of one of the 3 excluded by Sonos files with a different name and then to start removing the different tags from this file while trying to play the entire folder after each change, until the excluded file would not be excluded any more from the queue. Then, the plan was to do something similar with the track that showed in the queue with no name.
I started with selecting the same folder expecting to see, as I did many times in the last few days, 24 out of the 27 tracks to be added to the queue. To my surprise, after selecting the folder, all the 27 tracks were added to the queue and there were no tracks with no name in the queue. In other words, this time around, everything seems to be working as expected. No files on the NAS were changed or added or removed. However, the last thing I did yesterday was removing and readding the main folder in the library (with 99% of the files including the ones in question). I did this after rescanning the library. Rescanning did not help with anything; that is I still saw the same result which is 24 tracks instead of 27 and one track with no name.
It looks like removing and readding the (effectively entire) library changed the behavior to the correct one. The last time I did something like this was a few years ago. Perhaps Sonos logic used while reading the library files got smarter (some bugs got fixed) and now it handles better the files (names and tags) which created problems before. It also looks like rescanning does not help with fixing whatever was broken but remove/readd did fix it.
I shuffled the queue and I am playing it to see if it will stop again, but, this time, I am hopeful that it will work as expected as I see nothing odd in the queue. It looks like there are reasons why the CS rep had the remove/readd of the entire library on his list of things to try...
Thank you for your help!