I didn't see a whole lot of Matt Cappotelli (apart from his stuff with Johnny Jeter), but I thought that Jeter could have been a pretty good guy on the main roster. If memory serves, he had a very enjoyable match with Kanyon. The Spirit Squad gimmick really did him dirty.
The other standout memory I have of actual angles was CM Punk/Brent Albright, but that was Heyman's booking rather than Cornette's, I believe. After seeing that, I had high hopes for Brent Albright on SmackDown!, but alas. Same with Paul Birchall. The few memories I have of him in OVW, he came across really well.