2 years ago we rented a car in Dubai and drove down to Oman for about 5 days.
Really enjoyed the trip. The roads are great, locals are friendly and helpful, lots to see.
Its as dull as you make it, if you like to stay in a western chain hotel and never leave, then yeah, its gonna be dull. If you get out and explore, its certainly not dull.