1) A bit worse than average, maybe 10-20% worse than their coworkers. They still add plenty of value and with good management and time can be improved. Just not quite the "gem" hire.
2) Clearly unqualified/unsuitable for the role. Easy to spot and you can let them go with a couple of months serverence. Everyone is happy. Total cost maybe 3-4 months wages.
3) Qualified but toxic. Has negative value and can destroy a team. Problem is these people can get through tough interviews anyway. Having higher testing standards does nothing to stop these people.
On the other hand a good software engineer, working within a company and framework that supports them can easily add $1,000,000/year to the bottom line.
When I'm asked about how I'd hire I always look for adaptability, creativity, communication, taste. Unless our goal is to find something really skilled on alghorithims or a specific language, it's just ok if they are curious, passionate, and communicate.
That said, I still wonder why we put that much emphasis on the language or the algorithmic skills when what we really care about is culture, passion, and helpful communication.
Maybe it's just me but I feel like searching for a more human skillset seems worthwile in the long term
Even in the case the bad hire were completely untrainable and never managed to get anything past a code review, paying two salaries for the output of one Carmack-like outlier is still a bargain.