It's very early days here so I'm going to say this tentatively whilst touching ALL the wood...
I was really worried about my son going to school. He's awaiting an autism assessment - I know, I know "who isn't these days" blah blah blah. He's bright and curious but very anxious, very rigid, struggles with crowds and transitions amongst other things. We moved nurseries because the first one just wasn't right and he wasn't coping. The 2nd nursery was amazing, very supportive and he came on slowly but surely there.
We saw 3 schools and in the end opted for our closest - literally a ten minute walk, very good facilities, staff seemed very supportive and clued up, lots of space and lots of the children from the nursery go there. We don't need wraparound care so he's only there 8.45 till 3.15 and is home at 3.30 unless we go to the park. He wouldn't come with long days.
I was really worried about how big it is though (3 form entry for reception) and worried he'd get "lost" in all the chaos.
We had meetings before he started and some "reasonable adjustments" were agreed (just minor ones like being allowed his comfort item, ear defenders for the lunch room, staff knowing he may sometimes need a quiet space first thing) We got books on starting school, did practice runs with uniform and walking there in the mornings. The biggest plus was that he had a little group of friends going up with him from the nursery so he had some friendly faces straight away. His teacher also went to see him at his nursery (the school initiated this after seeing what a disaster the "stay and play" sessions were!)
Towards the end of his nursery time last year we were struggling to get him out of the house as his separation/transition anxiety had gotten so bad. I was genuinely on home schooling FB pages and doing research as I was so sure we'd have big issues.
Anyway... He is absolutely thriving. He loves school! The routine of going every day, knowing what they're doing each chunk of the day, having a lovely group of friends and supportive teachers is doing him the world of good. He won star of the week after a month or so for "bravery and resilience" when he went a whole week going in happily - I know everyone gets star of the week, but I cried when I read it because I was so proud of him, it really was a huge step forward for us that I didn't see coming at all.
He struggles after holidays and he found the pre Christmas chaos a bit too much, but the staff are amazing, they keep us informed and don't mind us calling to check after a particularly bad drop off or asking for a meeting when he's got appointments coming up so we have something from them to hand over etc.
I know it's early days and I'm very very aware that it's often year one or above when things start to come undone and we're already taking steps to prepare for next year. But his teacher thinks he'll actually continue to thrive as he'll love the more structured approach and he loves learning and taking it all in etc. They agree he'll need support and seem willing to help with that and we're prepared to advocate for him if needed.
I guess what I'm saying is, you might be surprised. Look for a school with supportive staff, ask local FB groups or friends with older kids (although everyone will have a different experience as no kids are the same, obviously) Almost all of my friends kids have loved it so far, they come home really proud to show what they've been doing or come out with funny stories about their day etc. But also if you feel really strongly about it, don't be afraid to think outside the box and look at other options!