[nstar]

This video might help with leak.
2006-2011 Cadillac DTS - How to fix leaking sunroof - YouTube
This thread on adjustment may help I know you said already tried.
.
Leaky Sunroof on 2007 DTS | Cadillac Owners Forum (cadillacforums.com)