> Is the new Gemini really that good?

yes, definitely one of the best models out there atm

> The "AI Overview" stuff on the google search page is so incredibly bad

because it has to have basically zero cost, that overview is a super basic model