Kingdom Hearts, I don't remember whether it was just the Disney element that put me off it, but I certainly incorrectly judged that game prior to playing it.
Destiny, I thought it looked meh, then I thought it was great fun after some mates convinced me to buy it, then a couple of weeks later I thought it was meh again, lol.
Rocket League, I respected it when I first saw it, it looked fine but it certainly didn't look like something that I'd enjoy, primarily with it being multiplayer only. Boy was I wrong, thank you Sony for giving it to me for "free".
Frequency, a mate bought it and I didn't give it the time of day, until of course I played it. I later played Amplitude to death when it came out.
Uncharted, in the early days of PS3 there wasn't a great deal of awesome games, I took a punt on Drake's Fortune because it was the big exclusive, I honestly wasn't all that bothered by the game before playing it. It was so much better than I ever thought it could be, not to mention how amazing the series became.
I imagine there's a load more, drawing a blank, unfortunately there's so much more that I thought looked great and ended up meh.
Don't ruin the moment
Currently Playing: Rocket League (PC/PS4), Dead Cells (PC)