Different varieties 'fall' differently. Bramley, the most popular cooking apple, falls easily, eating apples tend to stay firmer. And how much sugar you need depends how ripe the apples are, as well as variety. When I use early windfalls from my Bramley I do need sugar. By the time they are ready to pick they are a bit sweeter, no sugar needed (I'm happy with a little sharpness). As I store them they get sweeter. For some reason they seem to taste sweeter cooked than raw, though some eat them raw too.
Commercially they may be picked early and stored refrigerated so never get properly ripe.
But I also cook with my eating apples.
Cooking apples are also bigger, so less faff peeling them. Some varieties that grow big are classed as dual purpose - James Grieve, Crispin - neither particularly sweet, but nice.
Experiment. At the moment I am cooking with Granny Smith as that lasts the longest stored in my porch.