There's a bunch of special cases along these lines - As an Indian citizen, I'd normally need a visa to visit Mexico / Costa Rica but I live in the US on a work visa which means that the visa requirement is waived.

This is just one citizenship, country pair and I assume there's a lot more.