The right road bike will be comfortable. The wrong road bike will feel uncomfortable.
It's not an earth-shattering change. My hybrid and my road bike are almost the same as far as seat/bar/pedal relationships. My hybrid bars are a bit higher than my seat, my road bike feels great with my bar-tops a just slightly higher than my seat.
If you buy a cheap roadie to see if you like riding a roadie, you might end up with a bike that is uncomfortable because it isn't the "right" roadie for you.
Go test ride roadies, lots of them. Have the shop raise the bars to touring height and go for a ride! Write down your opinions of the various bikes so you can keep track of what you do and don't like about each one. Then take your list to your favorite shop, have someone sit down with you, and work on your list to find the right bike and components. And color. color is important! And saddle!
If you have a saddle you love, take it with you on your test rides.
"If Americans want to live the American Dream, they should go to Denmark." - Richard Wilkinson