[2D] How to make a camera metroidvania like ?

Hi, I’m trying to set up my camera for a 2D paper game, to work like it does in this videos.

or

Currently the camera is locked to Z axis and i wish have the same camera than metroidvania games but i don’t know how exactly

I have already follow this tutorial series below, twice to be sure, but doesn’'t work

Any help or tips you could provide would be appreciated!