ColdFusion Query Error: Value Can Not Be Converted To Requested Typehttp://www.bennadel.com/blog/194-ColdFusion-Query-Error-Value-Can-Not-Be-Converted-To-Requested-Type.htm
So, it is an old problem that never go away. Everything clicks now. Database schema was just updated with a few new columns. "SELECT *" combined with CFQUERYPARAM seems to have some caching issue and everything just messed up from there.
Solution? remove SELECT *, change to use explicit column names. The problem simply goes away for good.