The "I tried it and it sucked" is borderline conspiratorial at this point. There are enough talented, thoughtful developers saying there's something real here, and it is worth believing them and investing some time to understand it, even if you come out the other side and decide you don't want to use LLMs.
Use a very good model. Set up a good harness. Spend some time on your system prompts and skills. Develop your intuitions about how the model works, what it's good at, how to scope the work, and how to steer it. Recognize when it's alleviating menial work and recognize when it's making choices you really need to understand yourself. Be patient and accept that the failures are going to be very painful for a while.
Don't write it off until you've genuinely seen the upsides.