What is the best way for GIS users (i.e. consumers of data not power users) to load data into ArcMap from SDE?
A read-only file location that stores layer files that point to the SDE data?
Use an SDE connection in ArcCatalog and bring in featureclasses that way.