I had an aftermarket ASC mooroof on my '88 LE (bought the car used it came that way). It slid back into the roof and it also poped up and tilted. It wasn't too bad of an install, but I had problems with the controller. After I had it fixed once for about $160, I didn't bother with it anymore after it broke again.
As with any custom job, the quality of the installation will largely be in the hands of the installer. Get someone good and has good attention to details, and you will have a decent installation. Get someone who slaps it on and you'll regret it.
It's also an expensive job. A decent install will run you well over a grand.
If you don't need the full sliding moonroof, you can get pop-up/tilt only sunroofs for a decent price. Also they are much cheaper and reliable (no motor, no electronics).
I had one on my '85 Accord (bought this car used also, came that way). It wasn't anything fancy, but never had a problem.