Glassdoor.com lets you leave reviews of a company's interview process. :-)
You should always take glassdoor.com with a boulder of salt; one company I worked for that was a horrible sweatshop had a 4/5 rating on there, while my current job which I like much better had a 2.5/5 rating. So...YMMV. But it's still fun to read.
I don't have any "OMG HE ASKED YOU THAT" interview stories; I am pretty good at the soft stuff in that I usually know what they're going for when they ask soft skill questions and it gives me a lot of insight into what the job would actually be like. I've made up/down decisions based on those interviews alone.
I think a lot of employers also focus too much on the hard skills...like if you don't know every single SQL Server function or every single possible argument for CAST(), CONVERT(), SUBSTRING(), exact usage of wildcards in LIKE, etc. then you are an idiot and are unemployable. IMHO that's what the BOL are for...so I don't have to remember every minute detail about T-SQL. :-D
Plus, they sometimes completely ignore the fact that it can be easier to train someone to use SSIS/RS/AS from the ground up doing it exactly the way you want it done rather than getting someone who is very set in their ways and then you have to deal with a lot of pushback. It depends really on what you want done. If you need someone to just come in and do reports in the BI stack on an existing, well-established framework....a newbie can work out great if you invest a little time and patience. Give 'em a chance! Everyone has to learn this stuff somehow and some people (like myself) learn much better on the job than out of a book.