Little Rock isn't bad, but it isn't great either. No pro sports, not even much college sports, until the Razorbacks come to town.
Night life, I can't comment as I haven't lived there, but I have lived in south Arkansas and north Arkansas all my life and pass thru there quite a bit.
Certain parts of LR used to be bad, really bad... There are still parts you want to avoid, but I believe it has gotten better.
There is the Alltel Arena that has a lot of shows:
http://www.ticketmaster.com/Verizon...-Arena-tickets-North-Little-Rock/venue/221866
There is a pretty active music scene from what I recall. The river front if I am not mistaken.
They have the Clinton Library.
http://www.clintonlibrary.gov/
I think they have a minor league baseball team, the Arkansas Travelers.
Not sure how to compare the BBQ...
I think they still have a water park:
http://www.wildrivercountry.com/
They have a couple of descent malls, the McCain and Park Plaza, with PP being the better of the two.
The children's hospital is in Little Rock and is a great facility.
The only medical school in the state is in LR and hence the university hospital is also in LR.
They have an air force base there.
The summer's are sweltering hot in August/September. I mean, if you aren't used to high heat high humidity, you can't even begin to understand...
The winters can be rough, if there is snow or ice. People just don't know how to drive in it. But that is pretty rare, maybe once a year if you are lucky. I believe last year they had a few instances of winter precip, but that's pretty rare.
Not really sure about lakes or fishing, as I always went to Lake Degrey or south of there. Up here in northwest Arkansas we have Beaver lake. Never even looked at water life in LR.
They have an airport in LR.
Any specific questions? I'll try to answer what I can.