It will be great if we could create assignment rules to automate our organisation’s opportunity generation processes. I realised we can accomplish it today with workflow rules however this method becomes cumbersome when opportunity owner changes with stage or there is more complex business process.

Even better, why not have "Assignment Rules" for all Standard and Custom objects?