Bike fit can be a confusing thing. When I first got back into cycling my drop from seat to bars was about like your first picture. As I rode more often and further, I found that I needed the bars lower and lower. Had to wind up getting a new bike partly to satisfy that need to get lower.

But making generalizations, I will say that if you are a casual leisure rider going out for an hours ride, you'll probably want to sit up. Road bikes are not really designed for that, but you can make them work somewhat. If you are riding for fitness and at a higher effort for 2 or more hour rides, then as you get fitter, you might find as I did that lower in front is better.