Allow for flexible redirection methods on signin

[milindgoel15]

Goals

1. Full flexibility over redirection when signing in with CredentialsProvider
2. Introduces redirect options for both success and error responses

Non-Goals

No response

Background

So basically, when using the default signin function for CredentialsProvider, we provide a redirect boolean which we can use to redirect user to home URL in case of success or error page in case of error response. But say, we want to only redirect in case of success response and not when there is an error to handle the error in out custom signing page.

Proposal

Provide in 2 separate redirect boolean options (one for success, other for error).

Did a PR a while back but since my fork is outdated now and now actually targeting the correct branch (I think), I closed it today.
#9351

I can create a new PR with the proposal. Lemme know what branch I should target.