You would need a tbi-to-vortec intake manifold, I did this just for shitz on a high mileage tbi-350, but I just put in an rv cam, nothing special. I don't recall ever getting ecm errors, but I do recall the low rpm power getting a bit of a boost. It had the pulling power at 1800rpm of what used to take getting 2500rpm to do. Vortec replacements are usually the most sought after upgrade for the tbi, but they have a different egr routing, which may be what's caused some people issues.
Also, when doing a cam swap on a non-roller engine, you HAVE to change the lifters with the cam. It's the same as when you're changing the cam chain, gotta change gears with it.