Well, if kept short, Tornado is probably the most popular and well-designed foosball table out there. It can be found in bars all over the world and is the commonly agreed standard for tournaments. It celebrates precise, drill-heavy/zero mistakes style of play, hence professionals love it.
It’s also one of the most expensive tables around, no surprises here. But since that’s not what we’re going for (and it’s just a no-brainer when it comes to actual purchase) you won’t find big paragraphs or tips about Tornado. Important thing to mention is that the non-tournament model costs only about 1,200$ (which is basically a half of the price of Tornado Tournament 3000 Foosball table) and still provides all the great features you would want, except the coin op feature that is used to monetize tables in bars/pubs.
The price can vary greatly. The cheapest you can find will probably be on a local sale, or used in tournaments, somewhere in the range between $500-$600 is a good deal. Online is usually more expensive.