Our first Acura has been a long distance trooper for the family, and despite three transmissions, overall reliability has been outstanding. Only one of the transmissions actually failed, and it gave plenty of warning. Harper Acura in Knoxville, TN has been great in helping take care of maintenance and the trans issues. 140k miles and it is still a nicer ride than new Accords and Camrys.
Interior build quality and styling are top notch. Features are only now starting to feel dated, nine years later. Great balance between sporting/touring, and engine is smooth and strong.
Yes, transmission is a known issue, and it should be factored into ownership costs plans. Brakes are typical Honda (weak), but aftermarket rotors and pads up front helped.