The main reason I'm not going with Bubble is because I can't transfer users should I make another site, because of how password hashing works.

Otherwise everything else about it works fine. The nature of no code is that it scales terribly; it's often the best choice if you're building something in 10 hours, but bad if you have 1000 man hours. Code is code because it's the most efficient way to communicate. Startups are often willing to stick with it for a very long time though.