Since there’s a general trend in this direction - Tumbleweed already announced, Fedora is planing, Arch is planing (but there are already ALHP, CachyOS, this distro …), and Gentoo always existed - there are existing benchmarks. So you can just search for x86-64-v3 Linux benchmarks in general.
Afair there’s an indicated uplift of roughly 5 to 15%, with some software being slightly slower and some benefiting greatly.
I am also running core system packages in optimized variants for x86-64-v4 (Zen4 here which supports AVX512) , namely the kernel, mesa and wine-staging. It does not hurt performance, but there are some cases where I get more FPS in games with the optimizations vs when I don’t use them (minimal but noticable).
If Arch offers a way to get all packages in optimized variants, I would definitely use them - does not hurt, but can improve things.