I kinda like the idea but, at the same time, it has drawbacks. Though I guess that can be said of just about anything.
When it comes to Big Show, he's someone that can be hit or miss with me. I think Show does very well when he's in the kind of situation we've seen him in, overall, for the past 1.5 years. Show has been consistently booked and portrayed by WWE as a threat to any wrestler on the roster, even to the likes of John Cena. In the past, WWE has portrayed Show as a heel in which he's more of a bumbling lummox rather than an intimidating monster, at least most of the time. As a babyface, Show just never really clicked with me, especially when he was doing goofy stuff like imitating Hulk Hogan or dancing with Pee Wee Herman.
As far as having Show come back as a "Paul Heyman Guy", I don't really think Show needs it. Big Show is someone that's been an established star for more than a decade & a half with multiple title runs in the main event, mid-card and tag team scenes. Having Show as a "Paul Heyman Guy" wouldn't feel fresh to me at all. I'd prefer "Paul Heyman Guys", if WWE decides to expand Heyman's role further into something more akin to a stable, to be younger & fresh talent. On the main roster, I think wrestlers like Wade Barrett or Antonio Cesaro could truly benefit from being a "Paul Heyman Guy". Barrett's got all the ability to be a top tier player and I think Cesaro could be too if he worked on his mic skills or had a mouthpiece like Heyman. The jury is still out, at least with me, on Curtis Axel and I'm thinking that MIGHT be the plan. After all, they've generated a good deal of buzz about Axel without giving him a couple of victories over top guys like Triple H & Cena, but not anything approaching rock solid wins. As a result, people are still buzzing, talking and speculating about what will ultimately happen with Axel. If the plan is to give him a genuinely strong push, then WWE can milk this for a while longer.
As for what to do with Big Show, I'm not really sure at this time. There's a lot of younger talent in WWE and on their way up to the main roster that, frankly, I'd much rather see in the World Heavyweight Championship picture than Big Show. I wouldn't mind seeing him put into a tweener role and go after the US title for the ultimate purpose of putting over Dean Ambrose. After all, Show is a huge guy with a ton of title reigns in WWE, so Ambrose going over him in a program over the US title would only add onto his credibility. I could also see Show back in the IC title picture but I think that's going to be comprised of Barrett, Miz & Fandango for the time being, with Fandango ultimately capturing the title. A feud between Show & Fandango...I dunno, maybe. It's something that could definitely be hit or miss and more silly than anything else. If Fandango wins the IC title, I ultimately see him resuming his feud with Chris Jericho. I would suggest teaming Show with Mark Henry but Henry is taking time off and is apparently in a lot of hot water with WWE because of it. When he teamed with Henry a while back against Orton & Sheamus, Michael Cole used the term "Big Rules" while talking about their dominance. Personally, I think that'd be a great name for the two super heavyweight powerhouses.
So yeah, for me, I'd rather see Show in a program with Ambrose or form a strong team with someone to go after Rollins & Reigns eventually. After all, Big Show is someone that's been taken out by The Shield on several occasions, so that's all the explanation needed as to why he'd be put into a singles or tag team program against them. I don't think anything can be done with Show that's going to feel especially fresh. He's been around for such a long time for one thing and, as I alluded to earlier, there are younger & more exciting wrestlers on the roster that people are simply more interested in. At least in a mid-card or tag title feud, Show could be useful in putting over the young champion or champions.