Lists is an information tracking app in Microsoft 365 that enables users to work with anyone, anywhere. Users can configure lists to better organize events, issues, and assets.
It's great for anything that needs to hold data and process it into automation. It's a bit limiting if you like multi-line text fields or rich text fields. They lose a bit of their capability to filter.
It's great for everyday use, whether you adhere to the GTD regimen fully or just need a way to quickly capture and sort your tasks. However, it may be less suited if you're looking for a task manager that lets you collaborate with others or if you want to visualize your tasks in other ways, like a Gantt chart.
The interface of Things was good 10 years ago, and has been refined ever since. It's lightweight, while still being readable and showing just the information you need to see. Also, something I haven't seen in any other (of my) app(s) is the keyboard shortcut/launcher, where you start typing a letter, and a dropdown menu lets you quickly jump to a view.
They are all different but can be used for the same things. They all have different benefits, and I use them except Airtable. Trello has the best automation capabilities natively built into the product of any product I've ever used. (I've personally built over 1,000 automations or more for clients on Trello.) ClickUp has the best flexibility to view data in very different ways and from different organisation levels (i.e. High level data through to detailed specific data across multiple departments or projetcs. Microsoft Lists is an excellent choice if you work in M365 already and you want a deeply integrated way to hold data and use it within M365
I've tried numerous to-do apps, some that never even go out of beta. But I kept returning to Things, mostly for the user experience. It's unobtrusive and fast to use, and it looks fantastic, which is more important than I first realized. To become more organized, my app of choice needs to look organized. Also, many competing solutions are trying to force you into one way of using their app, while Things feels more open to letting you define your way of working with task management.