I can't speak for others; only for myself.
I have always had my own nodes running since 2017, sometimes lnd, sometimes cln, sometimes both.
At no time did I have the feeling (I have emphasized this several times at X and also here) that
1. - I can pack in funds in the volume I want because I didn't feel (my funds are) safe and
2. - the node / nodes worked well for me. There were mostly connection problems, failures, error messages.
For me, this had absolutely nothing to do with yield generation.
I am not disillusioned either.
I'm just still looking for the best possible souvereign solution for me in the LN network.