the choice depends on what kind of access you'd like to give to the new user.
Programmatic means that the user can access AWS resources only via the CLI, for example.
On the other hand, Console Management Acces means that the user can also access the AWS console using a password and their username. In this way they can access resources also from the console.
I hope I got it right and it makes sense to you.