I have a Fusion scenario that detects the creation of a new Company in Workfront, creates a matching Portfolio for it, then attaches a custom form to the Portfolio and fills it out. Another scenario detects a Project created for a specific Group, then gets the Company from the project and creates an appropriate Program for it in the right Portfolio.
As far as a request queue, you could build one for just about anything. It's mostly a matter of capturing all the information someone would need to take action on the request. Secondly, capturing anything that Fusion would need to take action, if that's the intended use case for the queue.