Without sounding too prejudiced, from what my friends and relatives who lived there, plus some of who I work with have said over the last year.... Hickville, major drug problems and boring as whale feces... but I can't speak from personal experience, so take all of that with some big grains of salt, they may just be unloading their frustrations when talking to me.
OTOH, in the summer, you are closer to Sylvan Lake and Rocky and the ECO offroad club and real estate isn't as bad pricewise.... so there may be balancing influences
I do know one guy who works there who loves it, tho he lives out of Red Deer per se.