The entire purpose of a MF_MISSILE object in Doom/SRB2 is to explode when colliding with any surface or solid object. If you want to create an alternate object for puzzle purposes, Lua will assist you in your task.
Meanwhile, NiGHTS gliding up slopes is just not having the collision properly implemented. Whilst this will be enabled by default, the No Physics flag will likely disable that.