I visit Ogden about monthly as well (the wife likes Target and Babies R Us) since we live in Logan which is about 45 minutes north of Ogden. Yes, Utah is 2/3 mormon but Ogden is sort of like the "diverse" city of Utah. Meaning they actually have diversity there and it's less mormon. There's a minor league baseball team, Ogden Raptors, that occasionally have Aggies playing for them (we've gotten Parker Dalton's and Brian Ruggiano's autograph).
The university (Weber State) area looks nice and there's skiing nearby. I don't know the area well enough to say where to live and what not but the closer you live to the mountains, the nicer it will be and more expensive. There may be some "rough" parts of town so it would be good to ask around the locals to get more of an idea of what you want.