Get what you want so you don't regret it later as stated by someone else above.
I have the FWD, I wish I would have gotten the AWD even if I'm in Texas. Reasons for wanting AWD:
- Performance. The car will use all four tires when it needs to. This means corner exits are much better, standing starts are much better and the car is better balanced when loaded up. Towing is better from a traction standpoint with AWD.
- Wet weather traction. Doing a quick right turn on an intersection on wet roads can be a safety issue on FWD. In my case, I was spinning the inside tires due to the wet roads and the car took some time to regain traction. Another example is doing a protected left turn where the incoming car is not stopping. (This happened to my sister and she flipped over her Corolla as a result.) You better be able to get on the power and quickly finish your left turn, or you get hit.
- Out of state road trips. Just because I live in Texas doesn't mean I'm only going to be driving in Texas. It would be great to have a car that can do a road trip into a snowy state. (You can argue that FWD with winter tires is better, however it doesn't make sense to use winter tires in Texas. All season tires with AWD is a good compromise here.)
- Better modding potential. This really ties into my first point about performance. If you somehow mod it to where it makes more power, or put wider wheels/tires on it, the AWD version will put your mods to good use.
There are certainly some advantages to going with FWD, like cheaper price and better MPGs. In my case, I get MPGs similar to owners driving AWD CX-5s, so really I only got the cheaper price benefit.