You've just got access to a bunch of side quests, that's all. If you enjoyed the main story and that's all you want to do then no need to purchase it. Queen's Brothel gets updated every month with new quests so if you want to read more stories and keep playing then it's worth it.