Moved to Spain and now can finally say I'm fluent in Spanish after studying and practicing for over a decade. I can read and write fairly well in Portuguese now, too, with basic speaking/listening skills, and picked up a bit of Catalan here as well, although that's mostly reading and listening.
Now I've been very slowly learning Arabic (Levantine dialect), I know the alphabet and got enough basic phrases under my belt to impress some of my husband's family members, but time and energy to devote to studying has really been limited.
I was never really interested in French or German but I think I will end up getting into them "accidentally" the way I did Portuguese. I find myself reading multilingual packaging here and I'm like, well, I can sort of almost understand that, why not go all the way? So if I start learning German, it will be because of Nesquick
I also did some Rosetta Stone Latin years ago, which turned out to be semi-helpful for physiology and Catalan, unexpectedly.
I would love to take a stab at Hebrew as an adult. I was so jealous of my Jewish friends who were learning it when we were kids that I forced them to teach me a little, and I still remember the alphabet song hehe.