But then I also don't end up with collections based on series. But that may be the way I have to go, if I stick with Calibre.
So this seems to be a matter of Calibre will do it the way YOU want (which is fine, as it is your program), but not the way that the user wants.
I would consider doing something for this, if I had the programming skills.