Does searching against double nested child reduce performance?

If your dB consists of many list fields and if these lists go beyond 100 entries … yes

If you want to go up the ladder from a third level up via parent objects that have many list fields … yes

Consider exploring the following resource (paid) that explains this and other aspects about how to build for performance: