Electricity and water don’t mix. So first think about what appliances you will be using next to the sink. A garbage disposal? Personally I would do a low backsplash because my sink area can get a bit messy when cleaning up, and a backsplash is much easier to clean than a window. But your idea sounds lovely!

I had a window with a shelf and frame around it. I did have electrical for a garbage disposal but outlets were set on the backsplash wall away from the sink.

However, I love your inspiration pics and would love a view more than outlets.

But "outlets or view" is not the available choice set. For a counter run that long, code is going to require outlets. More than one. If you want the window down to the countertop, you will need countertop pop-up outlets.

You could add a couple plugs on the front of the lower cabinets just in that section if you have your heart set on counter height windows. Flush or hidden.

They can be put on their side, as in your photo above, so the only limitation is the plate. I'd say 4" is the minimum to allow a few degrees of freedom in outlets, counter shimming, and tile.