Test data generation pain

I know mockaroo and faker are fine for simple flat data but when data has to connect these tools fall apart and I am back to writing seed scripts. Someone told me just use the APIs to create an important data, is that what people do? does it get slow with lots of rows? Please share what actually works for you guys?