What you are seeing with bumps is logged as: RH-79944 Bump map on ground plane imperceptible
Normal maps will look better. For instance like this.
That is using the Deep Water on GP material I posted a couple of years ago here
If the waves look tiny you will want to increase the size setting, like I did in the screen capture in this post.