I have problem at hand for which I'm confused about what is the best practice for going after it.

I have thought to intercept item creation process in Sitecore and read the site node properties. This idea is similar to what I have read regarding Site specific RTE HTML profiles.

Also solution should be extensible later to have per site/per language/per template wise workflows.

But is there any OOTB functionality for this?

If not what should be best approach to manage workflow with such cases?

P.S.: I have seen some projects to follow sprint-wise content workflows but that is not required by us.

Update

We have three types of user roles -

1 - Global team users 2 - Site specific admin users 3 - Site specific-language authors

Problem is for global users and users who are admin for multiple sites. When these users want to approve particular content from workbox and it is difficult for them to find in 1000+ content items in that workflow from all sites and language versions of the sites in workbox.