In my experience (~1.5yrs on small servers and partially a laptop) it is very stable, especially if you stick to the release branches, but even running master everywhere I've rarely run into any problems on that end.
Using pkgsrc for software is actually a good thing as it is portability-oriented to begin with and you get access to almost all of the packages in there out of the box. DragonFly support in pkgsrc has very much improved over the last year or so since one of the DF devs became a NetBSD/pkgsrc committer.
As for hardware support… YMMV. In my experience drivers tend to lag behind a bit and may or may not work for you. Give it a try.