Is implementing RAII via constructors and destructors considered bad 'Modern C++'?

With the advent of smart pointer in C++, is manually implementing RAII via constructors and destructors considered bad 'modern C++' practice? Or are there applications where this is still relevant?