Hi guys, thanks for all your insights. Just an update, I rode with the setup that I have on the OP with the curved part more or less level and the nose slightly up... yeah, it didn't work very well. I noticed lower back pain a few kilometers in and it got worse during climbs. It also got really uncomfortable on the drops. So I went back to the more or less level nose setup. Again, I tended to gravitate towards the nose, especially when in putting in power. Come to think of it, isn't that normal? On long rides I do get some saddle pain on the road but moving around the saddle and switching positions on the bike alleviates it. When I get home, no part of my body really hurts.
I'll borrow a relatively flat saddle from a friend and test it over the weekend.
(For context, I'm 165 cm tall with a short torso and longer than average arms and legs. I use a 100 cm stem (51 cm top tube) and I don't really feel stretched out or anything. My saddle to bar drop isn't that significant.)
P.S. I took the pic with the nose of the saddle pointed upwards.