So I posted about this on the *ahem, other forum* a while back. I won't link there because I haven't been there in 11 months due to disagreements with asshole mods, but here's an answer I got.
Unfortunately, it sounds like our best bet with the MK7 is always running to the fuse box...
"I tried this a while back with varying success.
You have a few options:
There is 12V key-on power... sort of. The power for the reading lamps can be tapped in to, but it blinks / fades with the cabin lights when the door is open. It also turns off when you activate the reading lamp. I used this to power a radar detector on my Tiguan, and it worked pretty well, as long as you didn't mind the power cycle any time a door was opened then closed.
The CarNet button cluster won't be much help directly. I mapped out all the pins/wires a while back in my "killing carnet" thread and there's no 12V constant or key power. However, if you removed the CarNet box, you could totally repurpose the button harness to provide 12V.
I have not checked sun roof wiring, but chances are it's similar to the Carnet harness - control only, no power.
Other than that, you're probably looking at tucking wires into the airbag pillar. It's not too bad if you can deal with the little pop-out slidey pins - there's a trick to releasing the trim without breaking anything. Then you can tie your new wiring to the existing wiring up the pillar without worrying about ill effects on airbag deployment."