For most people, the answer is yes. But it's never that simple.
The majority of hearing problems affect the high frequencies a lot more than the low ones. Therefore open fitting hearing aids sound a lot more natural and ones that block your ears up can make your own voice sound like you are talking with your head in a bucket. Therefore in-ear aids tend to be less natural.
However the true answer is we can't tell until we have had a look in your ears to assess the size of your ear canal, and until we have tested your hearing to see which frequencies are being affected.
People with wider ear canals tend to have more flexibility, also there are open fitting modular CIC hearing aids now that do not block your ears.
There is also the age old rule to consider, that a hearing aid will not help you if it's sat in the drawer gathering dust. If the only hearing aid you would be happy wearing is one that people can't see, then that's what you should get.
Most people can adapt to any type of hearing aid, as long as they know what to expect. Have an honest conversation with your audiologist as to what your needs are.