Here is what I have learned as a founder/manager who has built a team of 20 people so far (mix b/w remote and in-person, and hired and fired/lost a few along the way):
1. People who care about their work, get shit done and if their jobs are not time bound (e.g. Support), it doesn't matter whether they work from home or not. Even for roles where time sometimes is important (SLA etc), people with good ethics wouldn't be an issue remotely.
2. People who care but require a lot of guidance/supervision (may be entry level etc) are usually a little better off working in person closely with their peers and seniors so they can learn faster. They could transition to WFH/remote once they are up to speed. But early days, they are better off with their team in person. My 2 cents.
3. People who care BUT are doing the wrong job in the team/company. They are better off doing something else. They will fail whether working from home or in person. But they try and give it a shot genuinely. Still doesn't matter. Remote or in person.
4. People who don't care much, just want a job etc wouldn't matter whether are in person or remote. I have hired someone recently who just didn't give a shit (my fault for not seeing that during the hiring). he worked from office. didn't get shit done. Multiple rounds of feedback. He worked from home. Didn't get shit done. Didn't matter. He lasted 2 months which was a stretch.