What module bests fits my application?
Each choose of protocol have to fit onto constrants and requirements. Some protocol vs another protocol is always a tradeoff.

From your post I know what you need interoperability with tablets (smartphones). In fact you may use only Bluetooth Classic, Bluetooth Smart, WiFi.

First you need to decide:


Which bandwidth your need?
Which power budget you have?
Which protocol may be more fittable in your case?
Computational requirements (where is HCI is placed, how interract with module/chip) and code complexity?
Suitable pricing for each chip?


When you will ask for all question you may choose approtiate protocol.

For helping you I described main characteristics of each protocol.

Bluetooth classic (you can use SPP for it):


Typical current up to 50 mA
Typical bandwidth up to 1000 kbps (really up to 800) 
Suitable for simple case, remote control cases, audio streaming, raw data streaming from device.
Low computational requirements.
Low pricing.


Bluetooth Smart (aka Bluetooth Low Energy):


Typical current up to 8 mA;
Typical bandwidth 250 kbps (4.0), 1000 kbps (5.0)
Suitable for metering, smart devices, remote control, as replacement of a display, and cases for low power budget
Low computational requirements.
The lowest pricing.


WiFi:


Typical current up to 200 mA;
Typical bandwidth up to 300 mbps;
Suitable for video and audio streaming, cases with high payload, cases with SOHO devices intergration (mainly routers).
Middle computational requirements.
Middle pricing.