Thank you for the detailed explanation and for sharing the use case.
You are right, this is not a bug. Currently, Tabs and Accordion addons support Dynamic Content inside the existing items, but they do not support generating/repeating tab or accordion items automatically from Collections.
At the moment, the items need to be created manually, so use cases like dynamically generated FAQs, product features, or similar repeatable content are limited.
I understand how useful this would be when building a single dynamic layout for multiple product pages. I will forward this as a feature request to our development team for consideration in future improvements.