From my experience, the very top tier bootcamps basically function as an extended job interview. They select for people who either already have most of the skills needed, or who possess an extreme natural aptitude. Graduates from these programs can be effective programmers out of the gate. However, the pool of people who can pass these programs is extremely limited. The failure of many top tier bootcamps to scale points to this.
As for graduates from other programs, I place them in 2 buckets. The first is people who have substantial additional experience--they’ve been programming as a hobby for years, they learned python to automate work in their old career, they have a related career or degree etc... These candidates can also be extremely effective.
The second is candidates who have little to no experience beyond the bootcamp. These candidates from what I’ve seen are almost never a good fit. They generally come in below the level of a 2nd year college intern. 12 weeks just isn't enough time--barring extreme outliers.
The problem is that people who fall into the first set of candidates tend to be effective with or without bootcamp. My advice is that if you want to be a programmer, don’t pay thousands of dollars for bootcamp. Either take the time to go to school and learn the theory, or learn on your own through free or lower cost materials if you’re happy with CRUD jobs.
There are other ways to level up into more interesting work, but most people won’t learn the boring parts without external motivation and structure, and a CS degree is the easiest way to provide that.