The short answer is it depends. Many towns and cities have banned overnight parking in certain areas. In these locations, stealth camping would be illegal.
The residents are likely to be aware of the vehicles typically parked on their streets, and the presence of an unknown RV might make them uncomfortable.
If you are stealth camping without explicit permission to park, there is always a chance you will be asked (or told) to move in the middle of the night.