There are entire books written on this subject, but I can give a quick recommendation for common uses.
As above A36 (standard hot rolled mild steel) would be my first choice for a grinder base.
If you need steel with some toughness to it, the 4xxx steels are a good choice. The most common are 4140, 4150, and 4340.
For shaft type uses the 10xx and 12xx are useful grades
Use stainless for corrosion resistant applications, most common is 303, 304, and 316. Then there are the 4xx grades with a bit less corrosion resistance.
For applications requiring hardness, the various tool steels would be a good option. O1, W1, A2, D2, and S7 are the most common.
Browse through the McMaster steel selection, they have a basic write up on many of the uses. Also the listings gives some technical specifications on the various grades.
https://www.mcmaster.com/steel
I should add that whatever is on your shelf would proabaly work fine for home shop use.