As long as it fits, ime it’s fine. I can see the reliability argument- it’s a longer lever basically- but it’s never seemed to be a problem, maybe it wears the bushings just a little bit faster but they’re still longlived (especially as really long droppers tend to be better made), it doesn’t seem to cause any outright failure risks.
The only downside I’ve ever found is that with the 240mm dropper in my hardtail, the seat’s <completely> out of the way. Not just out of the way of me, but also of all the mud, I definitely get wetter and mankier on it than on any other bike I have. It’s like having a negative mudguard fitted.
The other thing is that I do reckon it’s diminishing returns, 185mm for me is about the point where it stopped feeling <too> short, every other time I added extra length it wasn’t just like “this is better”, it was “the old one was really obviously in the way”. But 185 to 210mm didn’t have as much impact, it was “this is better but it’s not night and day”. The feeling of going from “too little” to “good enough” is way, way bigger than going from “good enough” to “better”. I guess that tipping point is in different places for different riders.
210 to 240 was still worthwhile but it becomes a difference more like “if I had a choice I would choose this, if I already had the 210 I would not replace it”, most of the time.