I became CEng MRAeS about ten years ago. It's a moot point whether the actual qualification has done me that much good in itself, but without doubt the membership of the society, and access to the great and good of the industry have made a big difference.
On net - I'd recommend going for it, but don't expect it to open a great many doors that hard work and ability wouldn't have opened already.
G