while the above arguments are applicable to the concepts of men - created mental concepts of deities, the elephant staring us in the face is Creation, the incomprehensible vastness and energy locked up in it. that is where the "majesty" is lurking.
Control weather patterns? man is doing it on a small scale without violating the laws of nature, just nature perhaps.
The writers of ancient Holy books (biblia) tailored their picture of gods to the idea of the universe they had. We ought to develop / accept the existence of a creator that accommodate what has emerged as the true scope of creation. unless the cosmos made itself.