For most personal projects, hosting on the cloud may be overkill, but tempting with its supposed ease of use and benefits of scale. Self-hosting is often overlooked as a solution with the benefit of simplicity and cost.
Interesting discussion and demonstration of self hosting the kinds of apps most personal projects will end being.
ive never heard of anyone even getting a warning about hosting anything on a residential connection… many isps have verbiage about not doing it, but i don’t think any of them actually care because generally your upstream on a residential connection are so low it doesn’t matter if you saturate it often