Rooftop tents are fairly common here. I don't use one myself, but here are some observations:
1) Most are mounted on top of trailers or land-rover-type vehicles. in fact, I havn't seen any mounted on a 'normal' car.
2) these tents have a rigid, foldable base (does that make sense?). you don't sleep on the roof of the vehicle. you sleep on a rigid floor.
3) the systems is attatched so as to bear weight on the supporting structures of the car roof, not directly on the roof.
My personal opinion? If you do a lot of camping, and want a bit more comfort (not everyone likes to be too close to nature!), and you have the right car/trailer to accomodate this set-up, then I would consider it.
_________________________
'n Boer maak 'n plan
WOFT