Yes! Wholeheartedly agree. This has been a rather consistent source of confusion and a request from end users to do exactly what you've asked which we can't accommodate.
This is a much needed feature and I hope the R&D team will focus on it. Having an option for a flat dimension header structure would be a huge win!
We are working with multiple clients who are in the process of migrating their QV apps to QS and this has been a sticking point for adoption. Vizlib pivot tables provide this, but it's a paid solution. Would be nice to have out of the box as it would make adoption from QV to QS incredibly smoother.
Thank you all for your feedback on ways to improve our product. As you may know the tables are being reworked, you may have seen the new Nebula table. The column headers is on the shortlist of things we want to improve in the next version. Functionality of the new tables will grow over time, the new pivot is hopefully arrive during the spring of 2022.
Meanwhile, a hack could be to hijack the totals labels for dimension titles or use a straight table and hide duplicates with white font color.