After killing his mentor and having an encounter with Paleblood the hunter is transported into Equestria and if forced to adapt to a world of talking ponies with no need of his skills, with this the hunter is given his most difficult task to date, living peacefully and learning about friendship.
This story is going to have some major spoilers and assumes you have some knowledge of the game and its lore, if not,here's the bloodborne wiki.