Webflow’s path rules are quite strict regarding collection pages, so there’s no built in way to do this yet. If it’s a personal project, and you don’t mind some hacky redirects and scripting, you can achieve it, but definitely not something I’d advise for a production site;
Yes, it’s important to note though that when I do a build for a client, the complexity is primarily about the “path map.” When it’s a dynamic path map as in your case, it can become challenging when you exceed say 1,000+ remapped CMS items.
The reason is that it requires a lot more integration. Every time you change, add, delete a CMS item, we update a central path map in a key-value store for the rewriting and page generation, and then there also needs to be one large table of all maps that can be used for the dynamic sitemap adjustments.
If you’re interested in a build, you can drop me a message through the Sygnal site, or here by clicking my name. Send me some details such as your site’s readonly link and details of which CMS collections need dynamic paths and how they need to be constructed, and I can form a plan for the dynamic map generation.