Is ECC RAM latency noticeable in real-world use?

No, the difference is tiny – typically 1–2% at the same frequency and timings. For basically everyone outside of a lab, it’s imperceptible. If you need ECC for stability, don’t worry about latency.