I'd say there is a fourth category too - things that would be perfectly fine as a simple, local program purchased once that grow over-complicated cloud features to justify a subscription model.

Examples of this would be Lens, Postman and now Insomnia. This sort of behaviour is why I use k9s and Bruno instead.