Does the automatic transmission on honda preludes tend to have problems?

Yes, as did many of there 6cyl Honda's. Now Honda has partnered with GM for transmission technology. In return GM got V6 engines for the Saturn VUE for a few years.