Good watch, could watch again, and can recommend.
Eddie Murphy is almost always a good watch, even under his horrible Disney contract.
The sheer amount of production value in the movie to make the mansion look as good as it does, plus all the ghost effects, is daunting. The story is good, and the way they go about investigating the mystery is good in the traditional sense: a good cycle of drip fed information, search and discovery.
The premise of the haunting itself isn't that interesting, but it is somewhat compelling that it has a "Beauty and the Beast" vibe to it, and Terence Stamp does "creepy old guy" very well.
The kids are fun, and the movie has a certain amount of charm to it, but nothing about the movie really stands out as amazing.