Prompted sign-in should remain on whatever page the user is currently reading. This seems obvious but many big websites fail to do this and always redirect to their home page.