You're right, that sealer won't change the look of the stone at all. For several minutes as the sealer is applied and the stone is wet, it temporarily changes the color level...but then returns to exactly what the stone looked like before you started.
Sounds like you're looking for an enhancing sealer. They will generally make the color look as though it's wet, yet won't generally impart a higher sheen if you only apply one coat.
Enrich 'n Seal from AquaMix would be probably be my first choice because it works well and isn't hard to obtain.
511 Seal & Enhance is another. There are other possibilities. But I'd encourage you to stick with a well known brand. The good sealers are quite a bit more $ than most of the so-so products. But whatever you choose, it's very important to test in a small inconspicuous spot before committing to an entire countertop.
And do make sure you don't choose a topical sealer. A topical sealer, unlike what's previously been mentioned, sits on top of the stone like a film of varnish. They would generally impart a lot of sheen and require oodles of maintenance to keep them nice on a heavily used surface like a kitchen countertop.
