If a person is looking for a well fleshed out and rewarding story arc, then indeed CP2077 is disappointing on both fronts.
People looking for a futuristic hike simulation where it's possible to collect a lot of junk, explore a lot of alleys, then CP2077 is quite engaging. It took me around 60 hours to clear all the areas open to the player before even jumping on Dex's limo. (with the help of the official guide). I estimate there's around 200 more hours of freeform exploration and side gigs to do in the remaining part of the game. Some people play for the story, others keep these kind of games (like Skyrim, etc...) for that bit of spare time where you just want to look around, blow random stuff, relax after a long day of work, and to collect all the junk in hope of getting that piece of accessory you've never seen before.