The DEM functions in PostGIS allowed us to quickly analyze our SRTM raster. In the basic use cases, we were able to swap one function for another without any issues.
What is impressive about these DEM functions is that they are all wrappers around ST_MapAlgebra(). The power of ST_MapAlgebra() is in its adaptability to different problems.