Cowgirl is a position where the rider is able to have a lot of control. The rider can line things up in the way that feels best for them, which for some can turn an otherwise poor experience into something great.

I think the view is easily one of the best. People have more interesting fronts than backs.

A lot of your critique here is related to fitness issues. Intercourse is a strenuous activity, and if you want to get the most out of it, I highly recommend working out to improve your cardio - If you're not familiar with it, look into zone 2 heart rate training. It's a lot less intensive than what most people think of cardio, but gives fantastic results.