I tried a couple of Home Depot Super Glue brands which worked great for about 6 or 8 months each, then failed again. After the second time my glass fell out, I took the roof to a custom upholsterer for a plastic, sewn-in replacement -- my idea -- that looks OK. Not good, just OK, but it does a great job of keeping the rain out.
Appearance (and future clouding) is not a big deal, since I almost always drive with the top down. Seat heaters and an 85-degree blower into the footwells can compensate for most of Atlanta's chilly days.
By the way, the guy had some wild convertible top replacement fabrics: animal prints, metallic flake, and some electric solid colors. Maybe next time, I'll get the zebra print ...
'01 Nimbus Grey (stealth color) 225TTR ... Absolutely STOCK and damn proud of it -- until I crashed her very badly. Now she's mostly stock, but I'm still damn proud of her.