Search realoem.com, there may well be options...including my fix, which was $28 to fix what dealer wanted $1500 for...that was 15 years ago for my E36.
Many diys here on fixing sunroofs, realoem will show you parts explosion...you can order parts and drive to get them on sunny day or have them delivered to you...but opening up sunroof isn't so bad at all...but very worthwhile!
You have options...but will need to study up is all.
As desperate as this sounds, in comedy, 'likes' and 'views,' 'friends,' and 'retweets' really help. If I've ever helped you, please help me by friending, liking, viewing, and retweeting. It makes others think I have a following...it'll take you a minute or less. If you could, I'd really appreciate it!
A recent set--NSFW audio: https://youtu.be/_dcxcZfD6dg
Mangofy your E46!