Tenure is powerful, as is running your own dig or curating all the Egyptian objects in a museum. It's relative, though—relative to the institution you work for, how long you've been there, and whether or not you've managed to impress the people there who were powerful before you. If you're looking for a job that will change the world or make you the next Indiana Jones…that is very unlikely to happen. Your glory is likely to be limited to your own mind, your department, and maybe, if you are very lucky, a few academic journals that might be in print after you are gone. Unless, of course, you arrange to have yourself mummified, in which case you might end up being someone else's glorious discovery in a few thousand years….