What the other guys have said regarding the decay/stagnation of flying for CLE is correct. Many months, flying is shifted from either EWR or IAH to "beef up" the productivity for the CLE base. This means you may not fly much on reserve and may play the "I'm a lineholder, I'm not a lineholder" game.
All 3 bases have their ups and downs. If you want to go to CLE, you will probably get it. Most new-hires end up in either EWR or CLE but are able to hold IAH shortly thereafter.
There are good areas to crashpad or get an apartment in CLE both Northeast and South of the airport.
The RTA train runs straight into the airport and if you have a place Northeast of the field the train runs up thru downtown and each stop has busses at it to make a "lateral" connection.
http://www.gcrta.org/pdfs/maps/sysmapinside04.pdf
If you go south, you'll probably need a car.
CLE has income-based rent controls so if you get a crashpad or apartment your salary will actually be an "advantage."
If you like "city life," try the National Terminal Warehouse Apartments in downtown CLE. It is right near all 3 stadiums, The Rock Hall, a decent mall and movie theater, quick transportation to the airport (about 25 minutes), restaurants, bars, etc. The area is a little more expensive, but there is lots to do if you like to go out.
If you like the "urban life" try south of the aiport. A lot of people used to get apartments at the Polo Club in Strongsville, OH. It is right by a mall. There are other restaurants, etc. right around there as well.
If I remember correctly, both CLE and EWR have a State Income Tax, where IAH doesn't (offset by higher property taxes). I believe some parts surrounding CLE also have Municipal Income Taxes so you may wanna check on that.
Cost of livng in CLE is comparable to IAH for the most part but I'm not sure if the property taxes rival those in the Houston area

. EWR, of course, is more expensive if you stay close to the greater NYC area so many people move out into bordering PA or "cheaper" parts of NJ or NY. Many also commute to EWR.
As far as training is concerned, learn your limitations and immediate action items down cold. The training program here is first class and the instructors are all great people. Just pay attention and have a great attitude and you will do fine.