Use a Lightning app built in App Manager with standard navigation for most teams, and switch to console navigation the moment your users work many records side by side, like support agents on cases. Only go to code-built development with LWC, Apex or an AppExchange package when point-and-click can’t model the process.
We built the same custom app in Salesforce for the Ridgeline Supply operations team and checked it against a console app in the same org. By the end you will know which app type fits your users, and you will have the full App Manager walk-through to create it.