The upcoming comet you refer to is likely C/2022 E3 (ZTF). Its visibility and brightness are difficult to predict with certainty. While comets can sometimes become very bright, they can also be unpredictable and may not live up to expectations.