I can't remember if Silvio is all wheel drive or not, so my suggestions will include some RWD options:
1. Buy a newer Audi TT.
2. VW offered a Golf Sportwagen in AWD with available manual transmission in the US until 2019. We have the automatic version because it's my wife's car and that's what she likes. It's been reliable, gets good mileage, handles well and has plenty of room for road trips. Some of the earlier models were branded as Jetta--one of our daughters has a FWD TDI, which she loves.
3. Subaru offers a very reasonably priced AWD Impressa, which you can still get with a manual shifter.
4. If you want a little more style, more power, a bit more expense (but probably still cheaper than a late-model used TT) the Subaru BRZ or Toyota 86 is an elegant manual transmission RWD vehicle which you can buy brand new for under 30k. They come with a limited slip differential, so are probably okay in the snow.
5. Keep the TT on the road forever. It will be inconvenient, but probably the least expensive option to just keep fixing whatever breaks or wears out.