TL;DR If an executive comes to us and says "I have a new project X, here's what it's all about, let's get started." I want to be able to create a project, using a template, that already has 90%+ of the work (issue types and issues) defined. I want to use forms to take parameters, and customize tasks to the project. I want to be able to automate, wherever possible. I want to use Project dashboards to illustrate progress to leaders. When I template tasks, I want to use past experience to give rough time estimates. Then, at a high-level be able to roll up those estimates and give a rough ETA to leaders.
I've done my best to fully research this product, I've watched a few demo videos, read top-level documents, and I've tinkered with it by creating a POC project. I'm still unsure if it fits the bill. Here is what we need:
We need to track, automate, and show the progress of tasks related to software development projects. That's super bland, but, here are the details.
When a new project is created, I need tasks automatically generated with it. A project will go through phases; from project management, architecture, security... all the way to the application support team who will care for the app. These tasks don't vary much between projects, and so, when I create a new project, I need templated tasks created to represent commonly occurring units of work e.g. Create an architecture diagram - category Enterprise Architecture.
In addition to templated or canned tasks, it would be excellent to illustrate relationships between tasks beforehand. For example, "You cannot create a cloud resource, until the CyberSecurity tasks are complete" - or blocker relationships.
Wherever possible, we want to automate. So, imagine a task "Create project repository". The experience with this kind of task would be to inherit variables from another task; or present a form which a user would fill out. Then, after that task is approved, Jira would perform some back-end automation designed by our team in Automations to create a Bitbucket repository and / or project automatically.
Is this the right tool? Or am I barking up the wrong tree?
You said, "We need to track, automate, and show the progress of tasks related to software development projects. " That is all we need to know. :-)
You need to create a Jira Software Company-managed project, not a Jira Work Management project.