I went from flat bar to drops. Wouldn’t go back!
Try out different bars first and maybe stem length. I liked that it felt like a very fast mtb, but then when my body adapted I wanted more positions to play with. I’m mainly on the hoods for general, flats for steep and drops for fast. I like having the option and it makes long rides more comfortable.
Your motivation to ride it is a completely separate issue. Road is nowhere near as fun, but it does help your fitness/gets you places quickly/ makes walking about in lycra almost forgiveable.
If you give us some details on what’s not comfortable, we can feedback some adjustments. I find subtle adjustments make a big difference on the road bike.