Not as nice as real bedliner but it can work. I would recommend priming and flat black base coat before applying. Also it is more expensive and troublesome than carpet, as it will take many cans and several coats to achieve a nice thick texture.
I haven't tried to roll on version but I've heard that it may give better results and is more cost effective.