Honestly it's fine that the story is short to me. Lots of people have busy lives and won't beat even a 20-hour game for months (I have a friend who only recently got to "meet Hanako at Embers" and he had it from day 1, and they haven't done all the sidequests either). Would it be nice for it to be longer or more fleshed out? Sure, and I think that's something DLC is basically going to be made to do. In all honesty, I'm hoping that DLC can potentially double the length of the story, and I think there's a lot of potential for that.
This being said, I have no preference for shorter/longer stories. Another game I loved, The Outer Worlds, took me less than 25 hours to get 100% completion in terms of main and side quests, and I thought it was a fantastic game. Cyberpunk 2077 took me roughly 70 hours of gameplay time to 100% (plus or minus a few hours of open world exploration and whatnot), and I think that's a solid length for a game.
I honestly think a lot of games can overinflate the amount of content they have, consequently resulting in a lot of meaningless content ("Another settlement needs your help" for example, or there's the overwhelming size of contemporary Assassin's Creed games that are mostly filler that don't add much of importance to the story). I think what Cyberpunk makes up for in length (which even then isn't that short) is in its quality, just as The Outer Worlds did IMHO; the writing and level design is top-notch and I think is part of why this game is so good in my opinion, despite its flaws.