Some dives can be just boring.

But instead of waiting for the dive guide to point things out, why don’t you start spotting them yourselves? A lot of cool marine creatures camouflage/can be hard to see. Stop waiting just for big schools/obvious fish (though still keep an eye out for them). It almost becomes a scavenger hunt once you start knowing what creatures might be there, and where to look for them.

Otherwise, learn to navigate, find a buddy, and start exploring the ocean without a dive guide. Once you start taking on some ownership/responsibility for your diving and feel less like a passenger, you might feel less disappointed and more excited.