My favorite Japanese onomatopoeia is shiin (シーン), the sound of silence. Used both literally and figuratively if you're shocked into silence by something.

Interestingly, English has the latter use too, we just write it "..." and it doesn't have a pronunciation.

- Do you know where I store my dad jokes? In a dad-abase!

- ...