The required bosses aren't terrible. Shadow of Yharnam can be tough, Vicar Amelia is a pain in the ass, and Gehrman can be a nightmare. That said, if you want challenges, make sure to do the optional bosses as well.
Then, if you want true hell, the DLC ramps up the difficulty profoundly.