It appears the upcoming Cyberpunk 2077: Phantom Liberty expansion will be the RPG's only substantial piece of DLC, if a comment from the official CD Projekt RED YouTube channel is to be believed. When asked by a user if there's more content to come, the channel responded saying "Phantom Liberty is the only planned expansion for Cyberpunk 2077".
Prior to the game's release, it was stated that "at least" two expansions were planned for Cyberpunk 2077. However, it's possible the game's awful release and CD Projekt RED's decision to delay updates and free content meant the second DLC had to be scrapped. The Witcher 3: Wild Hunt was well supported with two expansions: Heart of Stone and Blood and Wine. We've reached out for comment from CD Projekt RED.
Revealed during a livestream yesterday, Phantom Liberty is an expansion targeting current-gen consoles — a version for PS4 isn't planned. It'll launch on PS5 next year and sees Keanu Reeves reprise his role as Johnny Silverhand while main character V swears an oath to the US government. It brings with it a new district in Night City and is described as a "spy-thriller".