I just went through this myself.
Go to a few different shops. Yes, a few because we all know what opinions are like. Try out as many different bows that you can get your hands on. Try them all if they'll let you. Don't worry about brand names or price tags or anything like that just try them and mark down a few that "felt" comfortable and easy to shoot.
Now that you have a list, do some research on them. Praise be to Internet. Not forum talk or bow magazine reviews or things like that but compare them to one another on their statistics. FPS, overall weight, length, draw weight, price. Knock that list down by a couple and then go try them again, once again "feeling" for the bow that best fits YOU! Not your buddy, not SlimJim on the internet, but you.
Now, you should have it down to 2 or 3 different bows in you mind. Now ask the sales guy for his opinion or your buddies. I'm a believer that the most important thing is the bow matching your body type and feeling comfortable while using it. I also believe this to be true for buying a new rifle.
I bought into this theory during my search and within a month, I'm poppin' the 8 and 9 ring on a consistant basis with a $300 brand new bow. Before my first trip to the store, I had only held a compound bow once but had never shot one. My whole new setup came in under 800 dollars including tax, arrows, case, release,... everything but broadheads. Still researching those.
There will be frustration for the first while, but consistant, GOOD practice will get you to where you want to be. Practice is not practice if you do the same things wrong all the time. Join a club and the guys and gals there will be more than willing to help you with your form. It's hard to watch yourself while shooting.
Like you, I was skeptical for so many years that it took me this long to get into archery. I'm a little upset with myself that it took this long because I'm hooked. I love the idea of the entire body working as one unit with the bow itself.