I've heard a few things about the transmission breaking and costing upwords of 4000 to fix, is this a serious common problem or is it kinda rare?

Should i stay away from the prelude?