I use an Intuos5 Medium with a Dell 30" LCD. It works amazingly well, except for the touch input, which is not on par with a modern laptop trackpad.
If you have a very large display, like mine, or use multiple LCDs, I'd recommend you to buy an Intuos. The higher resolution is very apparent when you map the tablet to a large display area. You can find a tablet size vs. LCD resolution chart here.
If you're using a display up to 1920 x 1080 pixels, like most 24" LCDs on the market, the Bamboo Create would suit you just fine. It's a great tablet that can be used for professional work just fine.
if you want something cheap then wacom bamboo is a good one. If you seriously want to go professional then a cintiq 24HD is the ultimate tablet that you can get. Its VERY costly but I heard its worth it.
Theres no such thing as the "best tablet" its really up to you. if you are new to tablet i suggest starting out with the cheaper (i use a bamboo connect,roughly 85-89.00 usd) why i say cheaper? because theres no need to spend a huge amount of $$$ for a really nice tablet especially if you have never used one before. i say gradually start going up the tablet chart. start out with the basic tablet, and then work your way up =]
There's no such thing as "The Best Tablet" or "Best Program." It all depends on the artist using them.
Wacom's are the most popular brand of tablets, but they're kind of like Apple in the sense that you end up paying more for the name. I personally use a VisTablet. I've had it for around four years and it still works great. It has great pen pressure, lots of customizable buttons on the version I have, and it was a much better price than a similar tablet from Wacom.