One thing I found is a maximum of 5000 files within a folder in hosted sharepoint.
The limitations you mention are not for regular OneDrive but apply only to the current "SharePoint online" (which is in any case changing). They do not apply to the "consumer" version of OneDrive.
Confusingly, there are two OneDrives. Though they have the same "OneDrive" name, they in fact are built on two very different technologies underneath:
*
OneDrive for Business: This is really just SharePoint online renamed to "OneDrive for Business". It comes with the more expensive Office 365 for business subscriptions. It has SharePoint functionality and repositories for collaboration, and even used to support your own websites. It also has filesize and filename limitations (certain characters are not supported). It is
not the OneDrive you get as a consumer.
*
OneDrive: this is what you get with your Microsoft account (on your Windows PC or Phone), and also with an Office 365 Home, Personal or Small Business subscription. This version of OneDrive does not have the current "SharePoint online" limitations. I have 240GB in 55 824 files on my regular "consumer" OneDrive, including family video/DVD images in the 5-7GB filesize range. Some files are nested more than ten levels deep, with very long filenames.
Unlike the
OneDrive for Business version, this ordinary "consumer OneDrive" does
not have the "SharePoint online" limitations. It supports all file formats, does automatic image tagging and album creation online in the cloud, is enabled for music and video streaming, and a whole lot more.
Though I have three OneDrive for Business accounts, all with unlimited storage, I never use them, preferring to stick with the "regular" OneDrive, where I have 1.2TB of available storage.
Microsoft has said it will in time converge these two different OneDrives and lift the limitations on the SharePoint version.
All my PCs and devices sync with this regular "consumer" OneDrive, so I can access all my files from anywhere. I have Windows Phone and Android devices, and they all have the OneDrive app installed.
The nice thing with this regular OneDrive is that in Win8.1 you can mark a file as local or online-only. If it's online-only, it stores a placeholder on your local drive but the whole file is actually online in the cloud OneDrive. This means your OneDrive folder is searchable just like a regular local Windows folder. If you click on a file that is online, it is automatically fetched (of course you have to be connected to the internet).
Another nifty little feature: when you delete a OneDrive file on any device or PC, the deleted file is moved to the online Recycle Bin, so it's always recoverable. If I delete a OneDrive file on my phone, for example, that deleted file is also in my PC's recycle bin. Nice.
All my Contacts and Calendars sync online, so phones and PCs are always in sync. Update a contact on my phone, and it's also in my desktop Outlook, online, and all other devices.
The OneDrive app is available for Windows, Mac, iOS, and Android. It's a fantastic little app, supports multiple OneDrive accounts, and is consistent between platforms.