Trade school vs traditional college? I need some help

I will be starting over at 27 (woot!) and I've been entertaining the idea of going to a trade school instead of community college then on to a 4yr. I've some done some research but I really need to hear from real people's experiences on going to a trade school versus a community college or university.

So reddit, what are the pros and cons? Do you wish you did things differently? Was it worth it?