I have not seen a better mapping tool than CartoDB. You get the familiarity of Google Maps with arbitrarily complex geographic data visualization on top. CartoDB excels at large data sets where Google Maps API completely chokes when attempting to handle more than ~1000 data points. I was able to plot 500,000 points on a map with reasonable speed and able to perform complex aggregations to display boundaries of areas containing certain types of data, intersections of those sections, and more.
Very suitable for any project where geographic data needs to be analysed or presented in a digestible format. There is more easy to use software for 3D and terrain work. For drilling data the plug in is limited and slightly clumsy in its execution although it is possible to draw the trace, snap to terrain and colour depending on geology, assay results, etc.
Learning curve - CartoDB might be difficult to use if you don't have a bit of SQL or data structures background. If you're not familiar with floats, strings, etc., you might upload an Excel file and be confused about how to manipulate it to get the software to create the maps that you want.
Performance - When I used it, there were some occasional issues with loading and parsing large data files.
MapInfo Pro customer support has always been quick and very helpful with any issues I have had with the software. They usually get back to you about your enquiry within 24 hours and they also tend to follow up to make sure your issue was resolved. I find it refreshing to be able to contact their experts quickly and easily.
Python is definitely a more powerful tool for data munging and analysis, but the python packages for geo-related data viz (bokeh, matplotlib, seaborn) are cumbersome to use. I would recommend doing your data analysis in Python and then exporting the final data to CartoDB for visualization. One benefit of doing this is that CartoDB can automatically publish your viz to a link or object, so you don't have to export it and host it yourself. Another benefit is that CartoDB automatically updates the viz once you change the data, eliminating the need to continuously regenerate image files. I haven't used Tableau too extensively, but from the experience I've had with it -- Tableau is better suited for traditional analytical visualization (charts, graphs, etc.) than for geospatial mapping and visualization.
QGIS works very well however I find it a little harder to use and find the tools/settings I need in QGIS. It has a lot of the same functionality as MapInfo however QGIS doesn't really offer a dedicated customer support form or service which makes it harder to learn the product.
