Is noexcept useless when not throwing is zero-cost?

Is the noexcept specifier useless if your implementation has a zero-cost (if nothing is thrown) exception model?

How does it compare to a non-zero-cost model?

Please discuss the most common compilers, e.g. MSVC, GCC, etc.