Maintenance: update issue templates + use Issue Forms

[dreamorosi]

Description of the improvement

Summary of the proposal
As per title, this issue serves to track the activity needed to update the issue templates to include other types like Maintenance, support Powertools, and Share your work - similar to what was done in Python.

Related issues, RFCs

N/A

[github-actions]

⚠️ COMMENT VISIBILITY WARNING ⚠️

Comments on closed issues are hard for our team to see.
If you need more assistance, please either tag a team member or open a new issue that references this one.
If you wish to keep having a conversation with other community members under this issue feel free to do so.