It'll be difficult to find a clean E36/E46 with an MT for around 3k$, an M3 would be the unicorn we are all looking for
Early Z4s and some Z3s are still rather "cheap" here in Germany, might be a good alternative (Z3 would definitely make a good Miata equivalent). But even those will not be easy to find at a budget of 3-5k$.