Do I really need auto range for automotive and household testing.
After all, working on a house, I know I'm not looking at 5000 volts AC and working on a car, I know I am not looking at 60 volts DC voltage.
Or what am I missing.
In measuring resistance ,is auto range better or something?
Auto-ranging isn't a critical necessity, but a manual range meter requires more knowledge & skill when probing an unknown circuit to keep from blowing the meter or injuring yourself if it happens (some can literally blow your fingers/hand off

).
Auto-ranging is more of a convenience than anything else, but can also be safer under some circumstances. If you've a single position for current on the selector switch for example, and you're not trying to put more current through the meter than it's designed for, it won't blow up in your hand. Otherwise, you still have to know what range to put the switch on, even with auto-ranging (or start at the highest range, and work your way down if you don't get a reading; comes back to knowledge/skill).
Another factor with cheap meters however, auto-ranging or not, is they may not meet their CAT ratings. For example, they may claim 600V CAT IV, and use 250V glass fuses internally. Other issues too, such as insufficient creepage distances/lack of cut-outs to prevent arc-over when probing an HV sources (within the meters specs). This is more common than you may think. There's an entire thread dedicated to this sort of thing over on the EEVBlog forum.