not really. There are several instance where being a bottom is not a bad thing. Again *spoiler alert*
1. Constantly losing fights to the chromatic dragons will let you to meet your posibly future husband (you're the bottom of course unless you want to the be top by defeating him, hardest fight in the game btw)
2. Defeating the eastern dragons made you a power bottom
3. You can bottom for the dragons that messes with a certain caravan.
So overall being the bottom is not a bad thing. But if you want to find the secret npc by beating frost, you can fight eastern dragon if you want to bottom, and choose get f*cked with territorial dragons (that's what i do)