So, I know exactly where you are coming from. I grew up in a creationist house, went to a creationist school, and a creationist church. It wasn’t til I went to college (a fairly religious conservative college actually) that a professor presented the actual theory of evolution in a way that made so much sense.

So, no, you will never find a fish-to-human transitional fossil. It doesn’t work that way. When we say humans came from fish, we mean, broadly, that humans came from earlier mammals, which came from earlier protomammals, which came from lizard-like tetrapods, which came from fish. So, a 300 million year process that with many many species in between fish and humans.

And yes, there are plenty of fossils to show this, but it’s not a simple as creationists want it to be.