A plug: if you are looking for TPC-style application-level benchmarks for database systems, check out the LDBC Social Network Benchmark [1]. It has workloads for both OLTP and OLAP systems. We designed both of these to prevent many of the common benchmarking mistakes. To ensure that implementations follow the specification and their results are reproducible, we have a rigorous auditing process (similarly to TPC's benchmarks) [2].
[1] https://ldbcouncil.org/docs/presentations/ldbc-snb-2022-11.p...
[2] https://ldbcouncil.org/benchmarks/snb/