The people that say leasehold is evil and to be avoided at all costs are people who have been burned by dodgy practices where leasehold has been misused and abused, generally by modern developers.
The other risk is short leases, which will significantly reduce the value of a property. You can renew a lease, but the shorter the lease, the more you need to do it, and the more they'll charge, so it's a bit of a hazard.
As said above, it's fairly unavoidable with flats - someone has to own and manage the building the flats are in, and if they aren't leasehold you end up with having a "share of freehold" situation, which comes with all its own problems of trying to manage a group of flat owners with different opinions.
There's also an awful lot of very benign situations where leaseholds have been used in the past. In my town almost everything is leasehold because of the way the town was developed. The only freehold houses you see here will be the ones where someone has exercised their right to buy the freehold. We tend to be on 999 year leases with a peppercorn ground rent here - I think the precise ground rent can vary a bit, but mine is £10 a year and although that's higher than specified in the lease documents (from 1919), it hasn't changed in at least the last 20 years, so I think there are very limited points at which it can be changed. Everyone has the right to buy a freehold now and I assume it's fairly inexpensive, but I haven't even had to stump up £200 on ground rent so far, so I can't see any point to buying it. For situations like this, there are no maintenance charges, no service charges and all of that, but you do have to get leaseholder permission for any major changes - I've added a driveway and an extension while I've been here and it was just a case of exchanging letters to get permission, no money. Leaseholder permission has always been a bit of a tick box exercise - if you can get conservation area and local council sorted, the leaseholder just go along with it.
The one you describe at 944 and zero ground rent sounds probably like mine. Is it a new town? I think it's more common in the sort of places where a huge planning corporation came in and built and managed a whole town. If it worries you, you'll have the right to buy the freehold after you've lived there a few years.