Logins through CB Connect should send them back to the page they attempted to login on. This assumes they used the CB Login Module links. If they were sent to the CB Login Page via an access denied error from Joomla it won't be able to send them back to the page they were trying to access at this time.