Bloodborne is amazing but I found its final 1/4 a bit underwhelming, as well as the final boss. I want a sequel sooooooo bad though (and Sekiro 2 also). Forbidden Woods, Hemwick Charnel Lane, and Cainhurst Castle are all awesome even though Id agree they feel a bit disconnected from the other main areas of Yharnam. Dark Souls 1 had my favorite world design but BB is close behind, and has my favorite music in the Souls(bornekiroring) series.
I havent played any DLC for any of their games or utilized any online features. I'll do that when they get eventual replays years down the road. It just seems so daunting to replay any of them right now, as they're quite big and they all kicked my ass hard.
I still need to finish Elden Ring. I prob put maybe 70 hrs into it and got stuck on Malenia, and was just feeling a bit burned out at that point. And I remeber being pissed cause I still couldn't figure out how to get up to that Catherdreal looking place on the cliff to the west of the Acadamy of Raya Lucaria and I'm way too stubborn to look anything up. I also, like you mentioned, just feel burned out on open worlds, even though the world itself in ER is beautiful and well designed, there are just too many tedious elements to it.