Robert,
Congratulations on your job offer. That is a hard question to answer. People's responses are subjective, but I will try to help.
First, what area are you moving from, and what industry do you work in? The area you are moving from and the industry you work in will make a big impact on how you feel about the city if you move here and also on what neighborhood (or neighboring city) you ultimately decide to live in.
Here are some of the pros and cons I can think of off the top of my head of living in Dallas...
Weather:
Pros - Fall is the best time of the year in Dallas, mostly because of football, but also because it is not monsoon raining, sleeting, or too hot.
Cons - The weather is erratic. Some people complain about it being too hot in the summer, but this is Texas. It gets hot. You will really appreciate ice in your water and tea during summertime here in Texas! 
Job Market:
Pros - Great job market for both big corporate jobs and small business. Tightly networked professional community.
Cons - Very competitive.
Food:
Pros: Dallas has A LOT OF RESTAURANTS and amazing food!
Cons: It is sometimes hard to decide which one to go too... 
Schools:
Pros - There are many schools in and around Dallas. Public schools, private schools, charter schools...you just have to research and find one near a neighborhood or surrounding suburb that works for you and your family's particular requirements / needs. There are several universities nearby too.
Cons - There is a lot of local drama over the public school system in Dallas, but that is true for every major city. Ignore it and choose the school / area that is right for your family. Even better - get involved in organizations helping to improve the local school system.
Transportation:
Pro & Cons:
Traffic is laughably bad for a city the size of Dallas, and the trains are of little use unless you are downtown. And moving outside of the city doesn't make traffic better...traffic is bad just about everywhere in and around Dallas.
The Uptown trolley is free and great to ride between Uptown, Museum / Arts district, and to part of Downtown. It moves pretty slow though. A lot of people who live in the immediate Uptown area ride the trolley to their jobs in Downtown. Keep in mind the trolley is BUSY on the weekends -- loads of tourists.
Dallas is overall not a bicycle or pedestrian friendly city, despite some roads marked as such. Motorists can be aggressive towards bicyclists, but it is getting better. Some neighborhoods in the city (i.e., Oak Cliff) have activist citizens pushing to make Dallas more pedestrian friendly. I have lived here 8 years, and their work has definitely resulted in some major changes. It IS possible, if you live in uptown and work from home or in downtown, to go days without using your car, but you will need to use your car if you live in a neighborhood outside of uptown.
Uber is also very popular and readily available here...many people use it every day.
There are two major air fields...Love Field and DFW International Airport, and some smaller private airports (i.e., in Addison, TX). Love Field is a short Uber ride from the city.
Sports:
Dallas loves sports!
Art & Recreation:
Pros - Dallas has a quiet but prosperous arts community with truly fantastic galleries, artisans, performers, music, and collectors. I am not really into the live music scene here, but I hear a lot of good things about it from friends that are into it.
Dallas has a fast improving / developing trail system, including the Santa Fe trail, the Trinity River Skyline Trail, the Katy Trail, and White Rock Lake trail. Katy Trail and White Rock Lake can get very crowded on the weekends and are better for walking / running. The Santa Fe Trail and Trinity River Skyline trail are great for running, walking, and cycling. There is also a horse park and trails.
Cons - There are a lot of Dallas citizens who have never been to the Design District, the trails, the Arts District, AT&T Center...people in Dallas can tend stay in the bubble of their neighborhood. That comes back to the tight-knit network / community thing.
Housing:
Pros & Cons:
I have heard that the average home price in Dallas is $190,000, but I have yet to see a single family home for sale that is even remotely in a convenient area and low crime area for that price. I have no doubt they exist, but the real estate market is HOT in Dallas. You will probably see prices closer to $350,000 - $650,000 to live in a neighborhood within the city itself that has lower crime and access to good schools and amenities (i.e., access to parks, trails, etc...) That is not to say there are not affordable homes in the city; but the nicer neighborhoods are definitely pricier and you will definitely compete with other buyers.
Rent is not bad like San Francisco and New York, but it pretty high considering the average income in Dallas.
Dallas is growing fast, and that is driving up housing costs. But it is still doable.
In closing, Dallas is a great place to work and do business. It is like a small town in some ways, where it can sometimes feel a little cliquish, but it just depends on if you are able to get in, network, and connect with people.
Dallas has some big city issues (i.e., traffic), but overall, most of the people in Dallas are very nice and will treat you like family.
My apologies for any typos! Hope this information helps!
